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

The data model that is produced from reverse engineering is:

an internal model.

a logical model.

None of these

a conceptual model.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

NOT EXISTS

None of these

EXISTS

Double use of NOT EXISTS

TRUE ANSWER : ?
YOUR ANSWER : ?

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

data modeling.

database design.

None of these

reverse engineering.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

create a complete backup of the operational database only.

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

All of these

test any changes on a test database only.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following SQL statements are helpful in database redesign?

None of these

Correlated subqueries only

Both of the above are helpful

EXISTS/NOT EXISTS expressions only

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is not terribly difficult if the:

database is well-designed.

database is structured.

database is relatively small.

database has no data.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑