Contents

Normalization


The process of organizing data into relational database in order to minimize duplication of information…..
a) normalization         
b) redundancy
c) duplication              
d) none of these

a

How many types of normalization in database?
a) one  
b) two 
c) three
d) four

c

Explanation: 1 Normal Form, 2nd Normal Form, 3rd Normal Form



Which of the following are types of anomalies?
a) update anomaly
b) insert anomaly
c) delete anomaly        
d) all of these

d

The insertion of each row and column contains only one value is called……..
a) 1st normal form
b) 2nd normal form
c) 3rd normal form
d) 4th normal form

a



Which of the following is removed in first normal form?
a) consistency             
b) integrity
c) repeating groups
d) none of these


c