Specialization in DBMS Multiple Choice Questions (MCQ) PDF Download

MCQ 1: The possible specialization constraint includes

1. disjoint and total
2. overlapping and total
3. overlapping and partial
4. all of above

MCQ 2: The leaf nodes in diagrams of generalization and specialization are considered as

1. extension classes
2. leaf classes
3. inverted classes
4. diverted classes

MCQ 3: The type of specialization in which all the subclasses have membership condition on super class of similar attribute is classified as

1. constraint-defined specialization
2. key-defined specialization
3. entity-defined specialization
4. attribute-defined specialization

MCQ 4: Consider representation of specialization and generalization, the blank triangle is used to indicate the specific constraint called

1. disjoint node
2. shared base constraint
3. schema construct
4. disjoint constraint