# Important MCQs of Data Base Normalization

## Important MCQs of Data Base Normalization

“Important MCQs of Data Base Normalization ” is the set of frequently asked Multiple Choice questions and these MCQs are asked in different test in the past in different test. Here, we are presenting those MCQs in a different style. Let’s begin with Set 1.

## Set 1: DataBase Normalization – FAQ MCQs by GRE

1. In which form of function there is no partial functional dependencies.

A.BCNF
B.2NF
C.3NF
D.4NF
E.none of these

B

2. which of the following is designed to cope with 4NF.

A.multi value dependency
B.join dependency
C.Transitive dependency
D. none of these
E. all of the above

A

3. which of the following is designed to cope with 5NF.

A.multi value dependency
B.join dependency
C.Transitive dependency
D. none of these
E. all of the above

B

A.dependency preserving and lossless join
B.not dependency and lossless join
C.dependency preserving and not lossless join
D.none of these
E.all of above

B

5. In which normal foam Boyee-code can operate?

A.first normal foam
B.second normal foam
C.third normal foam
D.all of above
E.none of these

D

## Set 2: Data Base Normalization – FAQ MCQs by GAT Subject Test

6.In which normal foam conversion of composite attribute to individual attribute happens,

A.first
B.second
C.third
D.four
E.none of these

A

7.In which key a table on the many sides of a one to many or many to many relationship must be in.

A.2NF
B.3NF
C.composite key
D.5NF
E.none of these

C

8. Defines the functions of tables in 2NF ?

A.BCNF
B.hidden dependencies eliminated
C.eliminating insertion anamalies
D.have a composite key
E.none of these

B

9. which one is false about normal foam?

A. BCNF is stricter than 5 NF
B. dependency preserving decomposition into 3 NF is always possible-Lossless
C. preserving decomposition into BCNF is always possible-Loss less
D. Any relation with two attributes is BCNF
F. None of these

C

10. constraints of functional dependencies are based on.

A. key
B. revisited key
C. superset key
D. none of these
E. all of the above

A

## Set 3: Data Normalization – FAQ MCQs by NTS Test

11. which foam defines the minimal data aggregates and repetitive groups.

A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF

C

12. which foam posses data about an individual entity.

A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF

D

13.functional dependency is based on which foam?

A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF

C

14.______________ and all tables in the database should be only one primary key.

A.2NF
B.3NF
C.key
D.primary key
F.composite key

B

15.Tables cannot have __________ on a Primary Key

A.2NF
B.transitive dependencies
C.join dependencies
D.multi-valued dependencies
E.none of these

D

## Set 4: Data Normalization – FAQ MCQs by NTS Test

16.composite key dont have any ___________

A.join dependencies
B.transitive dependencies
C.multi-valued dependencies
D.cyclic dependencies
E.none of these

D

17.normalization is used to design ________________

A.join dependencies
B.relational database
C.multi-valued dependencies
D.cyclic dependencies
E.none of these

B

18. in which normal foam value in each coloum is atomic .

A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF

A

19 ___________ is used to eliminate the drawback in the latest design of database

A.BCNF
B.2NF
C.normal foam
D.none of these
E.both a&b