Database Normalization of Relations Multiple Choice Questions with Answers – PDF Download

MCQ 1: The property of normalization of relations which guarantees that functional dependencies are represented in separate relations after decomposition is classified as:

1. nonadditive join property
2. independency reservation property
3. dependency preservation property
4. additive join property

MCQ 2: The process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as:

1. normalization of data
2. denomination of data
3. isolation of data
4. de-normalization of data

MCQ 3: The procedure of storing higher normal form relations which are in lower normal form as a base relation is classified as:

1. isolation of data
2. de-normalization of data
3. normalization of data
4. denomination of data

MCQ 4: In normalization of relations, the property which is critical and must be achieved is classified as:

1. nonadditive join property
2. additive join property
3. independency reservation property
4. dependency preservation property

MCQ 5: The joining property which guarantees that spurious tuple generation problem is not created after decomposition is called:

1. lossless join property
2. nonadditive join property
3. additive join property
4. both a and b