logo

CuriousTab

CuriousTab

Discussion


Home Database Data Models into Database Designs Comments

  • Question
  • The terms alternate key and candidate key mean the same thing.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Data Models into Database Designs problems


    Search Results


    • 1. Intersection tables are ID-dependent on both their parent tables.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. An ideal primary key is short, numeric and seldom changing.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. When the parent entity is required, a new child row can always be inserted.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. The data model produced from the reverse engineering process does not include intersection table data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. It is not easy to build a database correctly the first time.

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


    Comments

    There are no comments.

Enter a new Comment