Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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.
- Correct Answer
- place the values of the columns as attributes in the resulting XML document.
- 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
- 2. 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
- 3. 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
- 4. Which of the following indicates the maximum number of entities that can be involved in a relationship?
Options- A. Minimum cardinality
- B. Maximum cardinality
- C. ERD
- D. Greater Entity Count (GEC) Discuss
- 5. Which of the following products implemented the CODASYL DBTG model?
Options- A. IDMS
- B. DB2
- C. dBase-II
- D. R:base Discuss
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
Database problems
Search Results
Correct Answer: INSTEAD OF trigger.
Correct Answer: Nonrepeatable read
Correct Answer: to accomplish both of the above.
Correct Answer: Maximum cardinality
Correct Answer: IDMS
Correct Answer: Too much data
Correct Answer: Pull
Correct Answer: Enterprise data modeling
Correct Answer: You implement the new database.
Correct Answer: Attributes are assigned at the highest logical level.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.