Important MCQs of Data Base Normalization 

Prof. Fazal Rehman Shamil
Last modified on September 12th, 2020

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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
B

4. Define the function of BCNF ?

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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
C

12. which foam posses data about an individual entity.

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

Answer - Click Here:
D

13.functional dependency is based on which foam?

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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
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

Answer - Click Here:
D

17.normalization is used to design ________________

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

Answer - Click Here:
B

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

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

Answer - Click Here:
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

Answer - Click Here:
C

20.if the candidate key is determined then the table is in which foam.

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

Answer - Click Here:
C

Computer Science Repeated MCQs Book Download

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.