CIW-v5-Database-Design-Specialist-(1D0-541).pdf - CIW...

This preview shows page 1 - 6 out of 6 pages.

1D0-541 CIW CIW v5 Database Design Specialist
A. Only an update anomaly would occur. B. An insertion anomaly would occur. C. A deletion anomaly would occur. D. An update anomaly and a deletion anomaly would occur. Answer: C QUESTION: 121 Consider the following SQL statement and the Orders relation shown in the exhibit: What is the output of this SQL statement?
B. C. D. Answer: C QUESTION: 122 Consider the following relation definition: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 NOT NULL) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO CHECK ON UPDATE Which integrity constraint is violated in this relation definition?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture