Week #7.2 Quiz - CIST1220-Structured Query Language-SQL

The explanation below is an example of which constraint type? A primary key must be unique, and no part of the primary key can be null. A) Entity integrity B) Referential integrity C) Column integrity D) User-defined integrity

A) Entity integrity

One or more columns in a primary key can be null. True or False?

B) False

One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False?

B) False

The explanation below is an example of which constraint type? The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table. A) Entity integrity B) Referential integrity C) Column integrity D) User-defined integrity

B) Referential integrity

Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on: A) Both tables A and B get a new column and a Foreign Key. B) The table A C) The table B D) Nowhere, One-to-One relationships are not transformed.

C) The table B