Database Normalization Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” Database Normalization “. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on Database Normalization comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Database Normalization Mcqs

2.
For some relations, changing the data can have undesirable consequences called:

Referential integrity constraints

Modification anomalies

Normal forms

Transitive dependencies

3.
A relation in this form is free of all modification anomalies.

First normal form

Second normal form

Third normal form

Domain/key normal form

4.
If attributes A and B determine attribute C, then it is also true that:

A → C.

B → C.

(A,B) is a composite determinant.

C is a determinant.

5.
If attribute A determines both attributes B and C, then it is also true that:

A → B.

B → A.

C → A.

(B,C) → A.

6.
One solution to the multivalued dependency constraint problem is to:

Split the relation into two relations, each with a single theme.

Change the theme.

Create a new theme.

Add a composite key.

8.
4NF is designed to cope with :

Transitive dependency

Join dependency

Multi valued dependency

None of these

9.
5NF is designed to cope with :

Transitive dependency

Join dependency

Multi valued dependency

All of the above

10.
A BCNF is :

Loss less join and dependency preserving

Loss less join but not dependency preserving

Not loss less join but dependency preserving

None of these

11.
Every Boyee-Codd normal form is in

First normal form

Second normal form

Third normal form

All of the above

12.
Needing to using more complicated SQL in database applications is a(n) ________ of normalization.

Advantage

Disadvantage

Either an advantage or disadvantage

Neither an advantage nor disadvantage

13.
Eliminating modification anomalies is a(n) ________ of normalization.

Advantage

Disadvantage

Either an advantage or disadvantage

Neither an advantage nor disadvantage

15.
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

First step.

Second step.

Third step.

Fourth step.

0Shares
0
Scroll to Top