# Database Normalization of Relations MCQs Quiz Online PDF eBook Download

Practice database normalization of relations MCQs, database normalization of relations quiz answers for online computer science degree courses. Learn functional dependencies and normalization multiple choice questions & answers (MCQs), Database Normalization of Relations quiz questions and answers for computer majors. Learn relation schemas design, normalization: second normal form, functional dependencies, database normalization of relations test prep for free online classes.

Learn functional dependencies and normalization MCQ: property of normalization of relations which guarantees that functional dependencies are represented in separate relations after decomposition is classified as, with choices nonadditive join property, independency reservation property, dependency preservation property, and additive join property for computer majors. Practice merit scholarships assessment test, online learning database normalization of relations quiz questions for competitive exams in computer science major for best online schools for computer science.

## MCQs on Database Normalization of Relations PDF eBook Download

MCQ: 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

C

MCQ: 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

A

MCQ: 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

B

MCQ: 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

A

MCQ: 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

D