MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 30 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
A binary relationship is a relationship between two or more entities. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 2. |
Multiple and binary relationships are the same thing. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 3. |
A fact is a word or phrase that has a specific meaning for the business. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 4. |
A strong entity is an entity whose existence depends on some other entity type. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 5. |
No two attributes of the same entity type should have the same name. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 6. |
Some business rules cannot be represented in common data modeling notation. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 7. |
A time stamp is a time value that is associated with a data value. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 8. |
A logical representation of the data for an organization or for a business area is known as an entity-relationship model. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 9. |
Business rules and policies are universal. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 10. |
A binary relationship cannot be which of the following? |
| A. | One-to-One |
| B. | One-to-Many |
| C. | Many-to-Many |
| D. | Zero-to-Zero |
| Answer» E. | |
| 11. |
Relationships cannot have attributes. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 12. |
An attribute name should be which of the following? |
| A. | Singular verb or verb phrase |
| B. | Follow a standard format |
| C. | Use a alias |
| D. | All of the above. |
| Answer» C. Use a alias | |
| 13. |
Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 14. |
A good business rule is which of the following? |
| A. | Declarative |
| B. | Imprecise |
| C. | Redundant |
| D. | Compound |
| Answer» B. Imprecise | |
| 15. |
An entity name should be which of the following? |
| A. | A singular noun |
| B. | Specific to the organization |
| C. | Concise |
| D. | All of the above. |
| Answer» E. | |
| 16. |
A derived attribute is an attribute whose values can be calculated from a related relationship. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 17. |
Output reports should be included as part of an ERD. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 18. |
When the minimum and maximum number of instances of an entity is one, you know which of the following? |
| A. | Mandatory one |
| B. | Optional one |
| C. | Mandatory many |
| D. | Cannot tell |
| Answer» B. Optional one | |
| 19. |
A ternary relationship involves how many entities? |
| A. | 3 or less |
| B. | 3 |
| C. | More than 3 |
| D. | 3 or more |
| Answer» C. More than 3 | |
| 20. |
An oval represents which of the following in an ERD? |
| A. | Attribute |
| B. | Entity |
| C. | Optional One |
| D. | Relationship |
| Answer» B. Entity | |
| 21. |
A relationship is an association representing the interaction between attributes. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 22. |
When the minimum number of instances of an entity is one, you know which of the following? |
| A. | Mandatory one |
| B. | Optional one |
| C. | Mandatory many |
| D. | Cannot tell |
| Answer» E. | |
| 23. |
Which of the following conditions should exist if you want to convert a relationship to an associative entity? |
| A. | Some of the relationships for the participating entities are "many". |
| B. | The resulting associative entity has an independent meaning. |
| C. | The resulting associative entity has no attributes. |
| D. | All of the above |
| Answer» C. The resulting associative entity has no attributes. | |
| 24. |
A composite attribute is which of the following? |
| A. | An attribute that can be broken into components |
| B. | An attribute that cannot be broken into components |
| C. | Multiple attributes |
| D. | An identifier |
| Answer» B. An attribute that cannot be broken into components | |
| 25. |
An attribute is a person, place, object, event in a user environment. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 26. |
A good identifier is which of the following? |
| A. | One that can change over time |
| B. | Can be null |
| C. | One that is unique |
| D. | Be intelligent |
| Answer» D. Be intelligent | |
| 27. |
A rectangle represents which of the following in an ERD? |
| A. | Attribute |
| B. | Entity |
| C. | Optional One |
| D. | Relationship |
| Answer» C. Optional One | |
| 28. |
A relationship is which of the following? |
| A. | A person, place, or thing |
| B. | Property or characteristic of an entity |
| C. | Link between entities |
| D. | Weak entity |
| Answer» D. Weak entity | |
| 29. |
If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist? |
| A. | Derived attribute |
| B. | Optional one cardinality |
| C. | Multi-valued attribute |
| D. | Weak entity |
| Answer» E. | |
| 30. |
A binary relationship is which of the following? |
| A. | A relationship between two attributes |
| B. | A relationship between two entities |
| C. | An attribute with two different relationships |
| D. | An entity with two different relationships |
| Answer» C. An attribute with two different relationships | |