DBMS- Normalization Questions and Answers
DBMS- Normalization
Showing 10 of
26 questions
1. Normalization is a process of decomposing a set of relations with anomalies to produce smaller and well-structured relations that contains minimum or no redundancy.
- TRUE
- FALSE
2. A relation is said to be in 1NF if the values in the domain of each attribute of the relation are non-atomic.
- TRUE
- FALSE
5. When a relation R in 2NF with FDs A--->B and B--->CDEF (where A is the only candidate key), is deconposed into two relations R1 (with A-->B) and R2 (with B-->CDEF), the relations R1 and R2
(a) are always a lossless decomposition of R.
(b) usually have total combined storage space less than R.
(c) have no delete anomalies.
(d) will always be faster to execute a query than R.
- TRUE
- FALSE
6. 2NF is the removal of the partial functional dependencies or redundant data.
- TRUE
- FALSE
7. When a relation R in 3NF with FDs AB ----->C and C--->B is decomposed into two relations R1 (with AB---->null, that is, all key) and R2 (with C---->B), the relations R1 and R2
(a) are always dependency preserving.
(b) usually have total combined storage space less than R.
(c) have no delete anomalies.
- TRUE
- FALSE
8. In 3NF, no non-prime attribute is functionally dependent on another no-prime attribute.
- TRUE
- FALSE
9. In BCNF, a relation must only have candidate keys as determinants.
- TRUE
- FALSE
10. Lossless-join dependency is a property of decomposition, which ensures that no spurious tuples are generated when relations are returned through a natural join operation.
- TRUE
- FALSE