ExamVeda
Login
Home

ER Model and Business Rules - Database MCQ Questions and answers- Technical Aptitude

ER Model and Business Rules(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-3 section-1

21
Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
22
An entity instance of a subtype represents the same entity instance of a supertype.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
23
A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.
Discuss
Answer & Solution
Answer: Option A
Solution:
A supertype is an entity type that has a relationship with one or more subtypes.

It contains common attributes that are shared across all the subtypes.

Subtypes inherit these attributes and may have additional attributes of their own.

This structure helps in reducing redundancy and improving clarity in data modeling.

Therefore, the statement is True.
24
An ERD that has had the entities clustered will display more entities.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
25
Total specialization is represented by double lines between the supertype and subtype on an EER.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
26
Generalization is the process of defining more general entity types from a set of more specialized entity types.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
27
It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
28
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.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
29
Action assertions have traditionally been implemented within an application program.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
30
An entity cluster is a set of one or more entity types and associated relationships.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board