ExamVeda
Login
Home

Logical Database Design - Database MCQ Questions and answers- Technical Aptitude

Logical Database Design (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 null value is assigned when no other value applies.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
22
A synonym is two or more attributes that have different names but the same meaning.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
23
The primary key in a relation does not need to be underlined.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
24
In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
25
Normalization is a formal process for deciding which attributes should be grouped together in a relation.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
26
A candidate key must uniquely identify each row.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
27
Well-structured relations encourage anomalies of data.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
28
A foreign key may be null and still adhere to the referential integrity constraint.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
29
If a relation is in third normal form, it does not need to be in second normal form.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
30
The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board