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

1

The entity integrity rule states that:

A) no primary key attribute may be null. B) no primary key can be composite. C) no primary key may be unique. D) no primary key may be equal to a value in a foreign key.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

2

When mapping a many-to-many unary relationship into a relation which of the following is true?

A) One relation is created. B) Two relations are created. C) Three relations are created. D) Four relations are created.

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

3

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

A) First normal form B) Second normal form C) Third normal form D) Fourth normal form

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

4

A foreign key is which of the following?

A) Any attribute B) The same thing as a primary key C) An attribute that serves as the primary key of another relation D) An attribute that serves no purpose

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

5

A transitive dependency is which of the following?

A) A functional dependency between two or more key attributes. B) A functional dependency between two or more nonkey attributes. C) A relation that is in first normal form. D) A relation that is in second normal form.

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

6

When mapping a multivalued attribute into a relation which of the following is true?

A) One relation is created. B) Two relations are created. C) Three relations are created. D) Four relations are created.

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

7

If no multivalued attributes exist in a relation, then the relation is in what normal form?

A) First normal form B) Second normal form C) Third normal form D) Fourth normal form

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

8

A primary key is which of the following?

A) Any attribute B) An attribute that uniquely identifies each row C) An attribute that uniquely identifies each column D) A derived attribute

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

9

The relational model consists of:

A) data in the form of tables. B) data redundancy. C) operations using non-SQL languages. D) unorganized data.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

10

When mapping a binary many-to-many relationship into a relation which of the following is true?

A) One relation is created. B) Two relations are created. C) Three relations are created. D) Four relations are created.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board