PHYSICAL AND CHEMICAL AGENTS QUIZ

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

drop the primary key.

drop the table containing the foreign key.

drop the foreign key constraint.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Some organizations take the stand that no application should ever employ the true name of a table.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if:

any row in the subquery meets the condition.

both of these two conditions are met.

neither of these two conditions is met.

all rows in the subquery fail the condition.

TRUE ANSWER : ?
YOUR ANSWER : ?

Before any changes to database structure are attempted one should first:

clearly understand the current structure and contents of the database only.

test any changes on a test database only.

create a complete backup of the operational database only.

All of these

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 : ?

Which of the following SQL statements are helpful in database redesign?

Correlated subqueries only

Both of the above are helpful

None of these

EXISTS/NOT EXISTS expressions only

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is not terribly difficult if the:

database is relatively small.

database has no data.

database is well-designed.

database is structured.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑