logo

CuriousTab

CuriousTab

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. 


  • Database problems


    Search Results


    • 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


    Comments

    There are no comments.

Enter a new Comment