logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Data Models into Database Designs Comments
  • Question

  • When the parent entity is required and the parent has a surrogate key, update actions can be ignored.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • Data Models into Database Designs problems

    Search Results

    • 1. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Surrogate keys have much meaning for users.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. For every relationship, there are six possible sets of minimum cardinalities.

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Intersection tables are ID-dependent on both their parent tables.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. The terms alternate key and candidate key mean the same thing.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. 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
    • 10. (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

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