logo

CuriousTab

CuriousTab

Discussion


Home Database Data Models into Database Designs Comments

  • Question
  • For every relationship, there are six possible referential integrity actions.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Data Models into Database Designs problems


    Search Results


    • 1. The DBMS allows surrogate keys to be changed.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. The design guidelines and priorities for read-only databases are different because read-only databases are never updated.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. In 1:N relationships, which entity becomes the parent entity is arbitrary.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. A foreign key is used to implement relationships between tables.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. All primary keys are required.

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

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


    Comments

    There are no comments.

Enter a new Comment