QUESTION 14

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 S?

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 37

The data manipulation language defines

a. the schema or the structure of a database

b. the set of operations in a database system

c. both a. and b.

d. neither a. nor b.

QUESTION 44

A key in a relational database table

a. is a minimal set of attributes.

b. uniquely identifies a tuple (record) in a relation table.

c. both a. and b.

d. neither a. nor b.