DATABASE REDESIGN QUIZ

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

MODIFY TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

Adding null columns to a table is straightforward.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Two

Four

One

Three

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model that is produced from reverse engineering is:

None of these

a conceptual model.

a logical model.

an internal 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.

None of these

ambivalent

skeptical

optimistic

TRUE ANSWER : ?
YOUR ANSWER : ?

A tool that can help designers understand the dependencies of database structures is a:

data model.

None of these

dependency graph.

graphical display.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Correlated subqueries are similar to a regular subquery.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is not true of a correlated subquery?

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

The processing of the SELECT statements is nested.

They can be used to verify functional dependencies.

They are very similar to a regular subquery.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑