DBMS

1

Suppose x is  a component of some tuple and the domain for that component is integers. If X has the value NULL, what is the value of

I  0*X

II  x - x

A. NULL, NULL
B. 0, 0
C. NULL, 0
D. 0, NULL

2
The primary key is selected from the:


A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.

3

A network schema

A. stores data in tables
B. permits many-to-many relationship
C. Restricts the structure to one-to-one relationship
D. None of the above

4
A relation is in this form if it is in BCNF and has no multivalued dependencies:


A. second normal form.
B. third normal form.
C. fourth normal form.
D. domain/key normal form.

5
A relation NADDR is defined with attributes Name (unique), Street,City, State and Zip. For any given Zip, there is just one City and state. What is the highest normal form satisfied by above decomposition?


A. 1NF
B. 2NF
C. 3NF
D. BCNF