MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 27 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 subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
Total specialization is represented by double lines between the supertype and subtype on an EER.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
An entity cluster is a set of one or more entity types and associated relationships.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
There is cardinality on an EER between the supertype and subtype.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
An ERD that has had the entities clustered will display more entities.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 6. |
Action assertions have traditionally been implemented within an application program.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
A supertype can only have only one subtype.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
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. | True |
| B. | False |
| Answer» C. | |
| 10. |
An action assertion is a statement that expresses some aspect of the static structure of the organization.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
An entity instance of a subtype represents the same entity instance of a supertype.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
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. | True |
| B. | False |
| Answer» B. False | |
| 13. |
Packaged data models are meant to be exactly right straight out of the box.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 14. |
Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
Generalization is the process of defining more general entity types from a set of more specialized entity types.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 16. |
*$_A supertype/subtype hierarchy is which of the following?? |
| A. | Each subtype has only one attribute. |
| B. | Each supertype has only one attribute. |
| C. | Each subtype has only one supertype. |
| D. | Each supertype has only one subtype. |
| Answer» D. Each supertype has only one subtype. | |
| 17. |
*$_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. | |
| 18. |
*$_Which of the following is not one of the three ways to classify an action assertion?? |
| A. | Condition |
| B. | Integrity Control |
| C. | Authorization |
| D. | Enabler |
| Answer» E. | |
| 19. |
%_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 | |
| 20. |
_ Which of the following statements concerning business rules is true?$? |
| A. | It should be complex. |
| B. | It should not be convertible to computer code. |
| C. | It may include restrictions. |
| D. | All of the above. |
| Answer» D. All of the above. | |
| 21. |
_ Use of a supertype/subtype relationship is necessary when which of the following exists?$? |
| A. | An instance of a subtype participates in a relationship that is unique to that subtype. |
| B. | An instance of a subtype participates in a relationship that is the same as the other subtypes. |
| C. | Attributes apply to all of the instances of an entity type. |
| D. | No attributes apply to any of the instances of an entity type. |
| Answer» B. An instance of a subtype participates in a relationship that is the same as the other subtypes. | |
| 22. |
__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 | |
| 23. |
_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. | |
| 24. |
_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. | |
| 25. |
An oval represents which of the following in an EER?? |
| A. | Attribute |
| B. | Entity |
| C. | Optional One |
| D. | Relationship |
| Answer» B. Entity | |
| 26. |
Which one of the following symbols is not used in an ERD?? |
| A. | Rectangle |
| B. | Oval |
| C. | Diamond |
| D. | Circle |
| Answer» E. | |
| 27. |
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 | |