logo

CuriousTab

CuriousTab

Discussion

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

  • 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

  • Correct Answer
  • True 

    • Data Models into Database Designs problems

    Search Results

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

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

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

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

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

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

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

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

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Adding null columns to a table is straightforward.

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