Quiz 6

Question 1

The first step in assessing table structure includes ________.
a. Both counting rows and examining columns are correct
b. counting rows
c. examining data values
d. examining columns

Answer 1

a. Both counting rows and examining columns are correct

Question 2

You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity constraint:

SALE.CustomerNumber must exist in CUSTOMER.CustomerNumber

You run the following SQL query:

SELECT CustomerNumber
FROM SALE
WHERE CustomerNumber NOT IN
(SELECT CustomerNumber
FROM CUSTOMER);

What is shown in the results of this query?
a. All values of CustomerNumber that violate the constraint.
b. All values of CustomerNumber that match the constraint.
c. All values of Customer number that are in CUSTOMER but not in SALE.
d. All values of CustomerNumber where
SALE.CustomerNumber = CUSTOMER.CustomerNumber.

Answer 2

a. All values of CustomerNumber that violate the constraint.

Question 3

________ is the process of joining two or more tables and storing the result as a single table.
a. Querying
b. Updating
c. Denormalization
d. Normalization

Answer 3

c. Denormalization

Question 4

Referential integrity constraints are used to limit the possible values of a ________.
a. foreign key
b. candidate key
c. surrogate key
d. composite key

Answer 4

a. foreign key

Question 5

A relation is in fourth normal form if it is in BCNF and it has no ________.
a. deletion dependencies
b. transitive dependencies
c. multivalued dependencies
d. partial dependencies

Answer 5

c. multivalued dependencies