Database problems
- 1. 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
Correct Answer: INSTEAD OF trigger.
- 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
Correct Answer: place the values of the columns as attributes in the resulting XML document.
- 3. 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
Correct Answer: Too much data
- 4. 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 Discuss
Correct Answer: Pull
- 5. 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
Correct Answer: Enterprise data modeling
- 6. 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
Correct Answer: You implement the new database.
- 7. 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
Correct Answer: Attributes are assigned at the highest logical level.
- 8. Which of the following is an advantage of partitioning?
Options- A. Complexity
- B. Inconsistent access speed
- C. Extra space
- D. Security Discuss
Correct Answer: Security
- 9. 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
Correct Answer: Use compatible data types.
- 10. Stored procedures have which of the following advantages?
Options- A. It takes a longer time to write them as compared to writing Visual Basic.
- B. Data integrity improves as multiple applications access the same stored procedure.
- C. Network traffic increases
- D. Result in thicker client and thinner database server. Discuss
Correct Answer: Data integrity improves as multiple applications access the same stored procedure.
More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.