DATABASE REDESIGN QUIZ

Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.

None of these

skeptical

ambivalent

optimistic

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model produced from the reverse engineering process does not include intersection table data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Information systems and organizations do not just influence each other; they create each other.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

What SQL command can be used to add columns to a table?

ALTER TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

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

drop the table containing the foreign key.

drop the primary key.

All of these

drop the foreign key constraint.

TRUE ANSWER : ?
YOUR ANSWER : ?

The EXISTS keyword will be true if:

neither of these two conditions is met.

any row in the subquery meets the condition only.

all rows in the subquery fail the condition only.

both of these two conditions are met.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

All of these

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

create a complete backup of the operational database only.

test any changes on a test database only.

TRUE ANSWER : ?
YOUR ANSWER : ?

How many copies of the database schema are typically used in the redesign process?

Two

One

Three

Four

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑