DATABASE REDESIGN QUIZ

A regular subquery can be processed:

None of these

by nesting.

from the bottom up.

from the top down.

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

optimistic

skeptical

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

dependency graph.

None of these

graphical display.

data model.

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is not terribly difficult if the:

database is well-designed.

database has no data.

database is structured.

database is relatively small.

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL-92 command to change a table name is RENAME TABLE.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

MODIFY TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

A regular subquery is processed from the bottom up.

True

False

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

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

One

Three

Two

Four

TRUE ANSWER : ?
YOUR ANSWER : ?

↑