MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
________ is an abstraction through which relationships are treated as higher level entities |
| A. | Creation |
| B. | Superseding |
| C. | Attribute separation |
| D. | Aggregation |
| Answer» E. | |
| 2. |
If each higher level entity belongs to the lower level entity, then what kind of generalization is it? |
| A. | Modal generalization |
| B. | Partial generalization |
| C. | Total generalization |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 3. |
Condition defined generalization constraint is also said to be ________ |
| A. | Attribute defined |
| B. | Constraint defined |
| C. | Value defined |
| D. | Undefined |
| Answer» B. Constraint defined | |
| 4. |
_________IS_AN_ABSTRACTION_THROUGH_WHICH_RELATIONSHIPS_ARE_TREATED_AS_HIGHER_LEVEL_ENTITIES?$ |
| A. | Creation |
| B. | Superseding |
| C. | Attribute separation |
| D. | Aggregation |
| Answer» E. | |
| 5. |
IF_EACH_HIGHER_LEVEL_ENTITY_BELONGS_TO_THE_LOWER_LEVEL_ENTITY,_THEN_WHAT_KIND_OF_GENERALIZATION_IS_IT??$ |
| A. | Modal generalization |
| B. | Partial generalization |
| C. | Total generalization |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 6. |
Condition defined generalization constraint is also said to be _______? |
| A. | Attribute defined |
| B. | Constraint defined |
| C. | Value defined |
| D. | Undefined |
| Answer» B. Constraint defined | |
| 7. |
Which of the following is not a generalization constraint? |
| A. | Condition-defined |
| B. | User defined |
| C. | Disjoint |
| D. | Machine defined |
| Answer» E. | |
| 8. |
State true or false: The attributes of the higher level entity sets are inherited by the attributes of the lower level entity sets |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
Higher level entity sets are designated by the term _________ |
| A. | Sub class |
| B. | Super class |
| C. | Parent class |
| D. | Root class |
| Answer» C. Parent class | |
| 10. |
The similarities between the entity set can be expressed by which of the following features? |
| A. | Specialization |
| B. | Generalization |
| C. | Uniquation |
| D. | Inheritance |
| Answer» C. Uniquation | |
| 11. |
Which of the following is the specialization that permits multiple sets |
| A. | Superclass specialization |
| B. | Disjoint specialization |
| C. | Overlapping specialization |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 12. |
State true or false: Specialization can be applied only once |
| A. | True |
| B. | False |
| Answer» B. False | |
| 13. |
The process of designating sub groupings within the entity set is called as _______ |
| A. | Specialization |
| B. | Division |
| C. | Aggregation |
| D. | Finalization |
| Answer» B. Division | |