Bachelor Of Computer Science

Database Management System MCQs

CS: Database Management System MCQs - Subtopic

Normalization First Normal Form MCQ with Answers

Normalization First Normal Form Multiple Choice Questions (MCQ) to solve normalization first normal form quiz answers PDF worksheet, database management system test for online courses. Practice functional dependencies and normalization Multiple Choice Questions and Answers (MCQs), "Normalization First Normal Form" quiz questions and answers for information and communication technology. Learn database normalization of relations, normalization: second normal form, normalization: first normal form, equivalence of sets of functional dependency test prep to learn free online courses.

"If there is more than one key for relation schema in DBMS then each key in relation schema is classified as" Multiple Choice Questions (MCQ) on normalization: first normal form with choices prime key, super key, candidate key, and primary key for information and communication technology. Solve normalization first normal form quiz questions for merit scholarship test and certificate programs for top computer science schools in the world.

MCQs on Normalization First Normal Form

1.

If there is more than one key for relation schema in DBMS then each key in relation schema is classified as

prime key
super key
candidate key
primary key

2.

If the attribute of relation schema R is member of some candidate key then this type of attributes are classified as

atomic attribute
candidate attribute
nonprime attribute
prime attribute

3.

If the attribute of relation schema R is not a member of some candidate key then this type of attribute is classified as

nonprime attribute
prime attribute
atomic attribute
candidate attribute

4.

If each tuple have relation R within it then this type of relation is classified as

primary relation
prime relation
nested relation
atomic relation

5.

The normal form which only includes indivisible values or single atomic values is classified as

third normal form
first normal form
second normal form
fourth normal form