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
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
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
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
5. In which normal foam Boyee-code can operate?
A.first normal foam
B.second normal foam
D.all of above
E.none of these
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
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
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
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
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
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
12. which foam posses data about an individual entity.
A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF
13.functional dependency is based on which foam?
A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF
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
15.Tables cannot have __________ on a Primary Key
A.2NF
B.transitive dependencies
C.join dependencies
D.multi-valued dependencies
E.none of these
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
17.normalization is used to design ________________
A.join dependencies
B.relational database
C.multi-valued dependencies
D.cyclic dependencies
E.none of these
18. in which normal foam value in each coloum is atomic .
A. 1NF
B. 2NF
D. 4NF
E. 5NF
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
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