logo

CuriousTab

CuriousTab

Discussion


Home Database Physical Database Design See What Others Are Saying!
  • Question
  • A secondary key is which of the following?


  • Options
  • A. Nonunique key
  • B. Primary key
  • C. Useful for denormalization decisions
  • D. Determines the tablespace required

  • Correct Answer
  • Nonunique key 


  • 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