ExamVeda
Login
Home

Data Models into Database Designs - Database MCQ Questions and answers- Technical Aptitude

Data Models into Database Designs(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
A foreign key is used to implement relationships between tables.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
22
The terms alternate key and candidate key mean the same thing.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
23
In 1:N relationships, which entity becomes the parent entity is arbitrary.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
24
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
25
In a 1:1 relationship, the primary key placement is arbitrary.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
26
When the parent entity is required, a new child row can always be inserted.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
27
All primary keys are required.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
28
Intersection tables are ID-dependent on both their parent tables.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
29
For every relationship, there are six possible sets of minimum cardinalities.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
30
An intersection table is required to represent M:N relationships.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board