Modeling Data in the Organization - Database MCQ Questions and answers- Technical Aptitude

1

A binary relationship is which of the following?

A) A relationship between two attributes B) A relationship between two entities C) An attribute with two different relationships D) An entity with two different relationships

Discuss

Answer & Solution

Answer: Option B

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

2

If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?

A) Derived attribute B) Optional one cardinality C) Multi-valued attribute D) Weak entity

Discuss

Answer & Solution

Answer: Option D

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

3

A relationship is which of the following?

A) A person, place, or thing B) Property or characteristic of an entity C) Link between entities D) Weak entity

Discuss

Answer & Solution

Answer: Option C

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

4

Which of the following conditions should exist if you want to convert a relationship to an associative entity?

A) Some of the relationships for the participating entities are 'many'. B) The resulting associative entity has an independent meaning. C) The resulting associative entity has no attributes. D) All of the above.

Discuss

Answer & Solution

Answer: Option B

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

5

A good identifier is which of the following?

A) One that can change over time B) Can be null C) One that is unique D) Be intelligent

Discuss

Answer & Solution

Answer: Option C

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

6

A rectangle represents which of the following in an ERD?

A) Attribute B) Entity C) Optional One D) Relationship

Discuss

Answer & Solution

Answer: Option B

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

7

An entity name should be which of the following?

A) A singular noun B) Specific to the organization C) Concise D) All of the above

Discuss

Answer & Solution

Answer: Option D

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

8

An oval represents which of the following in an ERD?

A) Attribute B) Entity C) Optional One D) Relationship

Discuss

Answer & Solution

Answer: Option A

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

9

When the minimum and maximum number of instances of an entity is one, you know which of the following?

A) Mandatory one B) Optional one C) Mandatory many D) Cannot tell

Discuss

Answer & Solution

Answer: Option A

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

10

An attribute name should be which of the following?

A) Singular verb or verb phrase B) Follow a standard format C) Use a alias D) All of the above

Discuss

Answer & Solution

Answer: Option B

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