DATA AND DATABASE ADMINISTRATION QUIZ

Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Adding null columns to a table is straightforward.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A regular subquery can be processed:

by nesting.

from the bottom up.

None of these

from the top down.

TRUE ANSWER : ?
YOUR ANSWER : ?

It is not easy to build a database correctly the first time.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Typically, there should be at least two different copies of the database schema used in the redesign process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model produced from the reverse engineering process is a true logical model.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

drop the foreign key constraint.

drop the table containing the foreign key.

drop the primary key.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is especially difficult if the database has no data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Changing cardinalities in a database is:

a database design task that never occurs.

a rare database design task, but does occur.

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

a common database design task.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑