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-4 section-1

31
The DBMS allows surrogate keys to be changed.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
32
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
33
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
34
Surrogate keys have much meaning for users.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
35
When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
36
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
37
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
38
When the parent entity is required, a new parent row can always be inserted.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
39
For every relationship, there are six possible referential integrity actions.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
40
An ideal primary key is short, numeric and seldom changing.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board