DATABASE REDESIGN QUIZ

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

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

Reverse engineering is the process of reading a database schema and producing a data model from that schema.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

test any changes on a test database only.

create a complete backup of the operational database only.

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

All of these

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 ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

How can you find rows that do not match some specified condition?

NOT EXISTS

EXISTS

Double use of NOT EXISTS

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

↑