Post No 36

1. A ………………… specifies the actions needed to remove the drawbacks in the current design of database.
A) 1 NF

B) 2 NF

C) 3 NF

D) Normal form

2. A relation is in ……………………… if an attribute of a composite key is dependent on an attribute of other composite key.

A) 2NF

B) 3NF

C) BCNF

D) 1NF

3. Fifth Normal form is concerned with

A) Functional dependency

B) Multivalued dependency

C) Join dependency

D) Domain key

4. A table is in the ………………….. if only candidate keys are the determinants.

A) functional dependency

B) transitive dependency

C) 4 NF

D) BCNF

5. In 2NF

A) No functional dependencies exist.

B) No multivalued dependencies exist.

C) No partial functional dependencies exist

D) No partial multivalued dependencies exist.


6. The normal form that is not necessarily dependency preserving is
A) 2NF

B) 3NF

C) BCNF

D) 4NF

7. The …………….. is related to the concept of multi-valued dependency.

A) fourth normal form

B) fifth normal form

C) boyce codd normal form

D) third normal form

8. Which normal form is considered adequate for normal relational database design?

A) 2NF

B) 5NF

C) 4NF

D) 3NF

9. Dependency preservation is not guaranteed in

A) BCNF

B) 3NF

C) 4NF

D) DKNF

10. A relation is ………………. if every field contains only atomic values that is, no lists or sets.

A) 1 NF

B) 2 NF

C) 3 NF

D) BCNF

Answers:
1.D) Normal form

2.B) 3NF

3.C) Join dependency

4.D) BCNF

5.C) No partial functional dependencies exist

6.A) 2NF

7.A) fourth normal form

8.D) 3NF

9.A) BCNF

10.A) 1 NF