DATABASE REDESIGN QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

database design.

None of these

reverse engineering.

data modeling.

TRUE ANSWER : ?
YOUR ANSWER : ?

The use of the double NOT EXISTS can be used to find rows that do not match some specified 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 : ?

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

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if:

neither of these two conditions is met.

both of these two conditions are met.

any row in the subquery meets the condition.

all rows in the subquery fail the condition.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is not true of a correlated subquery?

They are very similar to a regular subquery.

The processing of the SELECT statements is nested.

They can be used to verify functional dependencies.

EXISTS/NOT EXISTS is a form of a correlated subquery.

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model that is produced from reverse engineering is:

None of these

an internal model.

a logical model.

a conceptual model.

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.

optimistic

ambivalent

skeptical

None of these

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

↑