BCA SEM - 2, GUJARAT UNIVERSITY
SUBJECT - DBMS(database management system)
CHAPTER - 4. NORMALIZATION OF DATABASE TABLES
MCQS
1.which of the following is not the basic types of data annomalies?
ANS : Redundancy anomalies
2.The first normal form makes sure that each cell in the table has properties.
ANS : no repeating groups
3.In which normal form partial dependency should not be allowed?
ANS : second normal form
4.Which of the following is a property of the first normal form?
ANS : All of these
5.Which of the following is not a rule of second normal form?
ANS : Transitive dependency should not be allowed.
6.The FD stands for:
ANS : Functional dependency
7.Which of the following statements is correct?
ANS : all of these
8.Who developed the normalization process:
ANS : E.F. codd
9.E.F.codd developed the normalization process in the which early:
ANS : 1970
This mcqs in the book of dotcom publication.