QUESTION 13

Please indicate what the highest normal form is for the given relation schema R(A, B, C, D), the key for the schema: AB, and the set of functional dependencies, A ? C, B ? D,

a.The first normal form (1NF)

b.The second normal form (2NF)

c.The third normal form (3NF)

d.The Boyce-Codd normal form (BCNF)

QUESTION 19

What kind of normal form data does the object-oriented database can handle?

a.BCNF, 3NF, 2NF, 1NF

b.Non first normal form

c.both a. and b.

d.neither a. nor b.

QUESTION 20

Copy of

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.