MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 24 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
Normalization is a formal process for deciding which attributes should be grouped together in a relation.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
A primary key may be null.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 4. |
If a relation is in third normal form, it does not need to be in second normal form.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
Weak entities do not get mapped into a relation.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
A foreign key may be null and still adhere to the referential integrity constraint.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
The primary key in a relation does not need to be underlined.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
A relation is a two-dimensional table.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
Well-structured relations encourage anomalies of data.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
A synonym is two or more attributes that have different names but the same meaning.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
A composite attribute does not get mapped into a relation.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 13. |
A candidate key must uniquely identify each row.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
A null value is assigned when no other value applies.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
An enterprise key is a primary key whose value is unique for a given relation.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 16. |
*/*_A transitive dependency is which of the following?? |
| A. | A functional dependency between two or more key attributes. |
| B. | A functional dependency between two or more nonkey attributes. |
| C. | A relation that is in first normal form. |
| D. | A relation that is in second normal form. |
| Answer» C. A relation that is in first normal form. | |
| 17. |
*/*_Relations are:? |
| A. | two-dimensional tables. |
| B. | three-dimensional tables. |
| C. | four-dimensional tables. |
| D. | five-dimensional tables. |
| Answer» B. three-dimensional tables. | |
| 18. |
*/*_When mapping a binary many-to-many relationship into a relation which of the following is true?? |
| A. | One relation is created. |
| B. | Two relations are created. |
| C. | Three relations are created. |
| D. | Four relations are created. |
| Answer» D. Four relations are created. | |
| 19. |
_ A foreign key is which of the following?$? |
| A. | Any attribute |
| B. | The same thing as a primary key |
| C. | An attribute that serves as the primary key of another relation |
| D. | An attribute that serves no purpose |
| Answer» D. An attribute that serves no purpose | |
| 20. |
_ When mapping a supertype/subtype relationship which of the following is true?$? |
| A. | The supertype primary key is assigned to each subtype. |
| B. | The subtype primary key is assigned to each supertype. |
| C. | There is no link between the supertype/subtype entities. |
| D. | There is no primary key/foreign key relationship between a supertype/subtype. |
| Answer» B. The subtype primary key is assigned to each supertype. | |
| 21. |
_ The relational model consists of:$? |
| A. | data in the form of tables. |
| B. | data redundancy. |
| C. | operations using non-SQL languages. |
| D. | unorganized data. |
| Answer» B. data redundancy. | |
| 22. |
_If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?$? |
| A. | First normal form |
| B. | Second normal form |
| C. | Third normal form |
| D. | Fourth normal form |
| Answer» C. Third normal form | |
| 23. |
When mapping a regular entity into a relation which of the following is true?$? |
| A. | One relation is created. |
| B. | Two relations are created. |
| C. | Three relations are created. |
| D. | Four relations are created. |
| Answer» B. Two relations are created. | |
| 24. |
A primary key is which of the following?$? |
| A. | Any attribute |
| B. | An attribute that uniquely identifies each row |
| C. | An attribute that uniquely identifies each column |
| D. | A derived attribute |
| Answer» C. An attribute that uniquely identifies each column | |