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

1

Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?

A) A domain constraint B) A range constraint C) An intrarelation constraint D) An interrelation constraint

Discuss

Answer & Solution

Answer: Option A

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

2

In a 1:N relationship, the foreign key is placed in:

A) either table without specifying parent and child tables. B) the parent table. C) the child table. D) either the parent table or the child table.

Discuss

Answer & Solution

Answer: Option C

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

3

Which of the following column properties specifies whether or not cells in a column must contain a data value?

A) Null status B) Data type C) Default value D) Data constraints

Discuss

Answer & Solution

Answer: Option A

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

4

A primary key should be defined as:

A) NULL. B) NOT NULL. C) Either of the above can be used. D) None of the above are correct.

Discuss

Answer & Solution

Answer: Option B

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

5

Which of the following column properties would be used to specify that cells in a column must contain a monetary value?

A) Null status B) Data type C) Default value D) Data constraints

Discuss

Answer & Solution

Answer: Option B

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

6

Which of the following situation requires the use of ID-dependent entities?

A) Association relationships only B) Multivalued attributes only C) Archetype/instance relationships only D) All of the above use ID dependent entities

Discuss

Answer & Solution

Answer: Option D

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

7

A foreign key is:

A) a column containing the primary key of another table. B) used to define data types. C) used to define null status. D) all of the above are above correct.

Discuss

Answer & Solution

Answer: Option A

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

8

Which of the following columns is(are) are required in a table?

A) A foreign key B) An alternate key C) A primary key D) A surrogate key

Discuss

Answer & Solution

Answer: Option C

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

9

In a 1:1 relationship, the foreign key is placed in:

A) either table without specifying parent and child tables. B) the parent table. C) the child table. D) either the parent table or the child table.

Discuss

Answer & Solution

Answer: Option A

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

10

Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?

A) Null status B) Data type C) Default value D) Data constraints

Discuss

Answer & Solution

Answer: Option C

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