Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
Options- A. Push
- B. Pull
- C. RFM
- D. OLAP
- Correct Answer
- Pull
- 1. The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
Options- A. Dirty data
- B. Inconsistent data
- C. Too much data
- D. Non-integrated data Discuss
- 2. The expression FOR XML RAW tells SQL Server to:
Options- A. place the values of the columns as attributes in the resulting XML document.
- B. place the values of the columns into elements rather than attributes.
- C. place some columns into elements and others into attributes.
- D. None of the above is correct. Discuss
- 3. SQL Server program code that is executed instead of an SQL command that needs to be processed is called
Options- A. INSTEAD OF trigger.
- B. BEFORE trigger.
- C. AFTER trigger.
- D. BEGIN trigger. Discuss
- 4. Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
- 5. A reason for using an SQL view to hide columns is:
Options- A. to simplify a result only.
- B. to prevent the display of sensitive data only.
- C. to accomplish both of the above.
- D. None of the above are reasons for using an SQL view. Discuss
- 6. The first step in database development is which of the following?
Options- A. Enterprise data modeling
- B. Logical database design
- C. Physical database design and definition
- D. Database Implementation Discuss
- 7. In enterprise data modeling, which is incorrect?
Options- A. You review current systems.
- B. You implement the new database.
- C. You describe the data needed at a very high level of abstraction.
- D. You plan one or more database development projects. Discuss
- 8. A supertype/subtype hierarchy has which of the following features?
Options- A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
- B. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
- C. Attributes are assigned at the highest logical level.
- D. Attributes are assigned at the lowest logical level. Discuss
- 9. Which of the following is an advantage of partitioning?
Options- A. Complexity
- B. Inconsistent access speed
- C. Extra space
- D. Security Discuss
- 10. Which of the following improves a query's processing time?
Options- A. Write complex queries.
- B. Combine a table with itself.
- C. Query one query within another.
- D. Use compatible data types. Discuss
Database problems
Search Results
Correct Answer: Too much data
Correct Answer: place the values of the columns as attributes in the resulting XML document.
Correct Answer: INSTEAD OF trigger.
Correct Answer: Nonrepeatable read
Correct Answer: to accomplish both of the above.
Correct Answer: Enterprise data modeling
Correct Answer: You implement the new database.
Correct Answer: Attributes are assigned at the highest logical level.
Correct Answer: Security
Correct Answer: Use compatible data types.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.