logo

CuriousTab

CuriousTab

Discussion


Home Database ER Model and Business Rules See What Others Are Saying!
  • 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. Attributes are assigned at the highest logical level.
  • C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
  • D. Attributes are assigned at the lowest logical level.

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


  • More questions

    • 1. A benefit of using a stored procedure is that it can be distributed to client computers.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. Nonclustered indexes are faster than clustered indexes for retrieval.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. A null value is assigned when no other value applies.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. XML is a rapidly developing scripting language that may, in conjunction with XHTML, replace HTML.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. With an asynchronous system, the requesting system waits for a response in real time.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Business Intelligence (BI) systems do not obtain their data by which of the following means?

    • Options
    • A. Read and process data from an operational database
    • B. Process transactions
    • C. Process extracts from operational databases
    • D. Process data purchased from data vendors
    • Discuss
    • 9. An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. The Windows operating system and Windows applications are event driven.

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment