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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]A[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]D[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]A[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]A[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
12. which foam posses data about an individual entity.
A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]D[/su_spoiler]
13.functional dependency is based on which foam?
A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
15.Tables cannot have __________ on a Primary Key
A.2NF
B.transitive dependencies
C.join dependencies
D.multi-valued dependencies
E.none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]D[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]D[/su_spoiler]
17.normalization is used to design ________________
A.join dependencies
B.relational database
C.multi-valued dependencies
D.cyclic dependencies
E.none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
18. in which normal foam value in each coloum is atomic .
A. 1NF
B. 2NF
C. 3NF
D. 4NF
E. 5NF
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]A[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
