DATABASE REDESIGN QUIZ

The process of reading a database schema and producing a data model from that schema is known as:

database design.

None of these

data modeling.

reverse engineering.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ambivalent

None of these

optimistic

skeptical

TRUE ANSWER : ?
YOUR ANSWER : ?

Changing cardinalities in a database is:

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.

a database design task that never occurs.

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Correlated subqueries are similar to a regular subquery.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

Correlated subqueries only

EXISTS/NOT EXISTS expressions only

Both of the above are helpful

TRUE ANSWER : ?
YOUR ANSWER : ?

What SQL command can be used to delete columns from a table?

ALTER TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑