Normalization First Normal Form Multiple Choice Questions (MCQ) PDF Download

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

1. prime key
2. super key
3. candidate key
4. primary key

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

1. atomic attribute
2. candidate attribute
3. nonprime attribute
4. prime attribute

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

1. nonprime attribute
2. prime attribute
3. atomic attribute
4. candidate attribute

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

1. primary relation
2. prime relation
3. nested relation
4. atomic relation

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

1. third normal form
2. first normal form
3. second normal form
4. fourth normal form