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. |
If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 2. |
Total specialization is represented by double lines between the supertype and subtype on an EER. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 3. |
A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 4. |
It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 5. |
Action assertions have traditionally been implemented within an application program. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 6. |
An entity cluster is a set of one or more entity types and associated relationships. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 7. |
An ERD that has had the entities clustered will display more entities. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 8. |
An entity instance of a subtype represents the same entity instance of a supertype. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 9. |
There is cardinality on an EER between the supertype and subtype. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 10. |
Specialization is which of the following processes? |
| A. | Defining one or more subtypes of the supertype and forming supertype/subtype relationships. |
| B. | Defining one or more supertypes of the subtype and forming supertype/subtype relationships. |
| C. | Defining one or more subtypes of the supertype and not forming supertype/subtype relationships. |
| D. | Defining one or more supertypes of the subtype and not forming supertype/subtype relationships. |
| Answer» B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships. | |
| 11. |
A supertype can only have only one subtype. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 12. |
Which one of the following symbols is not used in an ERD? |
| A. | Rectangle |
| B. | Oval |
| C. | Diamond |
| D. | Circle |
| Answer» E. | |
| 13. |
A supertype/subtype hierarchy has which of the following features? |
| A. | Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype. |
| B. | Attributes are assigned at the highest logical level. |
| C. | Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype. |
| D. | Attributes are assigned at the lowest logical level. |
| Answer» C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype. | |
| 14. |
An action assertion is a statement that expresses some aspect of the static structure of the organization. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 15. |
A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s). |
| A. | 1 |
| B. | |
| Answer» B. | |
| 16. |
Generalization is the process of defining more general entity types from a set of more specialized entity types. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 17. |
A subtype 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. | |
| 18. |
When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following? |
| A. | Disjoint with total specialization |
| B. | Disjoint with partial specialization |
| C. | Overlap with total specialization |
| D. | Overlap with partial specialization |
| Answer» D. Overlap with partial specialization | |
| 19. |
Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 20. |
An oval represents which of the following in an EER? |
| A. | Attribute |
| B. | Entity |
| C. | Optional One |
| D. | Relationship |
| Answer» B. Entity | |
| 21. |
When an entity instance must be a member of only one subtype, it is which of the following? |
| A. | Disjoint with total specialization |
| B. | Disjoint with partial specialization |
| C. | Overlap with total specialization |
| D. | Overlap with partial specialization |
| Answer» B. Disjoint with partial specialization | |
| 22. |
A subtype discriminator is which of the following? |
| A. | An attribute of the supertype whose values determine the subtype |
| B. | An attribute of the subtype whose values determine the supertype |
| C. | An attribute of the supertype whose values determine the supertype |
| D. | An attribute of the subtype whose values determine the subtype |
| Answer» B. An attribute of the subtype whose values determine the supertype | |
| 23. |
Packaged data models are meant to be exactly right straight out of the box. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 24. |
A rectangle represents which of the following in an EER? |
| A. | Attribute |
| B. | Entity |
| C. | Optional One |
| D. | Relationship |
| Answer» C. Optional One | |
| 25. |
Inheritance is which of the following? |
| A. | When a supertype entity inherits values of the subtype attribute |
| B. | When a subtype entity inherits values of the supertype attribute |
| C. | When a supertype entity inherits values of another supertype attribute |
| D. | When a subtype entity inherits values of another subtype attribute |
| Answer» C. When a supertype entity inherits values of another supertype attribute | |
| 26. |
An action assertion must include which of the following? |
| A. | Anchor object |
| B. | Action |
| C. | Corresponding object |
| D. | All of the above. |
| Answer» E. | |