Contents

Which is generally normalization process?
a) reduce number of relation                            
b) increased number of relations
c) reduce functional dependency    
d) increase functional dependency

b

The process of producing a simpler and more reliable database structure is called
a) normalization               

b) anomalies
c) integrity                            

d) constraints

a

Which of the following are purposes of normalization?
b) reduce amount of data
c) relationship between entities
a) design efficient               

d) all of these

d

A relation is automatically in…….
a) first normal form
b) second normal form
c) third normal form                                          
d) Boyce-Codd normal form

a

Which of the following operation perform in first normal form?
a) remove repeating group                             
b) remove functional dependency
c) remove partial dependency                         
d) none of these

a

Which of the following operation perform in second normal form?
a) remove repeating group                
b) remove functional dependency
c) remove partial dependency                         
d) none of these

b