Database Redesign

To drop a column that is used as a foreign key, first:

A:

drop the primary key.

B:

drop the table containing the foreign key..

C:

drop the foreign key constraint.

D:

All of the above must be done.

Answer: C

No answer description is available. Let's discuss.

📖

The data model that is produced from reverse engineering is:

A:

a conceptual model.

B:

an internal model.

C:

a logical model.

D:

None of the above is correct.

Answer: D

No answer description is available. Let's discuss.

📖

The NOT EXISTS keyword will be true if:

A:

any row in the subquery meets the condition.

B:

all rows in the subquery fail the condition.

C:

both of these two conditions are met.

D:

neither of these two conditions is met.

Answer: B

No answer description is available. Let's discuss.

📖

Changing cardinalities in a database is:

A:

a common database design task.

B:

a rare database design task, but does occur.

C:

a database design task that never occurs.

D:

is impossible to do, so a new database must be constructed and the data moved into it.

Answer: A

No answer description is available. Let's discuss.

📖

The EXISTS keyword will be true if:

A:

any row in the subquery meets the condition only.

B:

all rows in the subquery fail the condition only.

C:

both of these two conditions are met.

D:

neither of these two conditions is met.

Answer: A

No answer description is available. Let's discuss.

📖

Questions for: Database Redesign