QUESTION 8

Given table R(A,B,C) and S(C,D,E), which of the following SQL statements would find the record(s) with null values on the column C in table R?

a. select * from R left outer join S where R.C = S.C;

b. select * from R right outer join S where R.C = S.C;

c. either a. or b.

d. neither a. nor b.

QUESTION 11

If there is a one-to-many relationship between entity A and B, then

a. there exists a functional dependency from the primary key in A to the primary key in B, i.e., PK(A) ? PK(B).

b. there exists a functional dependency from the primary key in B to the primary key in A, i.e., PK(B) ? PK(A).

c. both a. and b.

d. neither a. nor b.

QUESTION 12

In __________________, the number of (first-level) index entries is equal to the number of distinct index values in data file.

a. primary index

b. cluster index

c. secondary index

d. multi-level index