Extended ER Features Multiple Choice Questions with Answers – PDF Download

MCQ 1: The database user assigns entities to a given entity set, in the type of generalization's constraints:

1. Data-defined
2. User-defined
3. System-defined
4. Condition-defined

MCQ 2: By default, the generalization type applied is:

1. Dependent specialization
2. Partial specialization
3. Complete specialization
4. Total specialization

MCQ 3: An abstraction through which relationships are treated as higher-level entities, is known as:

1. Aggregation
2. Tabulation
3. Simulation
4. Patriotization

MCQ 4: In the user-defined constraints on generalization, the lower level entity sets can be of type:

1. 2 types
2. 3 types
3. 4 types
4. 5 types

MCQ 5: Like attribute inheritance, the inheritance that applies through all tiers of lower-level entity sets, is known to be:

1. Participation inheritance
2. Execution inheritance
3. Existence inheritance
4. Dependency inheritance