logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ ER Model and Business Rules See What Others Are Saying!
  • Question

  • Use of a supertype/subtype relationship is necessary when which of the following exists?


  • Options
  • A. An instance of a subtype participates in a relationship that is unique to that subtype.
  • B. An instance of a subtype participates in a relationship that is the same as the other subtypes.
  • C. Attributes apply to all of the instances of an entity type.
  • D. No attributes apply to any of the instances of an entity type.

  • Correct Answer
  • An instance of a subtype participates in a relationship that is unique to that subtype. 

    • More questions

    • 1. JDBC Type 1 drivers are JDBC-ODBC bridge drivers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

    • Options
    • A. a particular column in a particular underlying table.
    • B. a particular column in a particular row.
    • C. a particular row in a particular underlying table.
    • D. None of the above is correct.
      • Discuss
    • 4. Sequences guarantee valid surrogate key values.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. With SQL Server optimistic locking, an update lock is placed on the row when the row is read.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Views can be used to show the results of computed columns.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A proxy server controls the passage of messages or files through to the organization's network.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. No two attributes of the same entity type should have the same name.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Independent data marts are often created because an organization focuses on a series of short-term business objectives.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.