DATABASE REDESIGN QUIZ

Which SQL-92 standard SQL command can be used to change a table name?

None of these

ALTER TABLE

CHANGE TABLE

RENAME TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is not terribly difficult if the:

database is relatively small.

database has no data.

database is structured.

database is well-designed.

TRUE ANSWER : ?
YOUR ANSWER : ?

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

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

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

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

If a database is built correctly the first time, it will not have to be redesigned.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑