MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 26 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Business rules and policies are universal.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
A logical representation of the data for an organization or for a business area is known as an entity-relationship model.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
No two attributes of the same entity type should have the same name.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
Relationships cannot have attributes.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
A time stamp is a time value that is associated with a data value.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
Multiple and binary relationships are the same thing.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
Some business rules cannot be represented in common data modeling notation.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
A strong entity is an entity whose existence depends on some other entity type.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 10. |
Output reports should be included as part of an ERD.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
A binary relationship is a relationship between two or more entities.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 12. |
A fact is a word or phrase that has a specific meaning for the business.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 13. |
An attribute is a person, place, object, event in a user environment.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 14. |
A relationship is an association representing the interaction between attributes.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 15. |
A derived attribute is an attribute whose values can be calculated from a related relationship.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 16. |
*/*_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 | |
| 17. |
*/*_A good business rule is which of the following?? |
| A. | Declarative |
| B. | Imprecise |
| C. | Redundant |
| D. | Compound |
| Answer» B. Imprecise | |
| 18. |
*/*_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 | |
| 19. |
_ 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 | |
| 20. |
_ 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. | |
| 21. |
_ 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. | |
| 22. |
_An oval represents which of the following in an ERD?$? |
| A. | Attribute |
| B. | Entity |
| C. | Optional One |
| D. | Relationship |
| Answer» B. Entity | |
| 23. |
_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 | |
| 24. |
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 | |
| 25. |
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. | |
| 26. |
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. | |