logo

CuriousTab

CuriousTab

Discussion


Home Technical Questions Database Comments

  • Question
  • 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.

  • Correct Answer
  • Attributes are assigned at the highest logical level. 


  • Database problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. Which of the following is an advantage of partitioning?

    • Options
    • A. Complexity
    • B. Inconsistent access speed
    • C. Extra space
    • D. Security
    • Discuss
    • 7. 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
    • 8. 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
    • 9. A distributed database can use which of the following strategies?

    • Options
    • A. Totally centralized one location and accessed by many sites
    • B. Partially or totally replicated across sites
    • C. Partitioned into segments at different sites
    • D. All of the above
    • Discuss
    • 10. A distributed database is which of the following?

    • Options
    • A. A single logical database that is spread to multiple locations and is interconnected by a network
    • B. A loose collection of file that is spread to multiple locations and is interconnected by a network
    • C. A single logical database that is limited to one location.
    • D. A loose collection of file that is limited to one location.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment