Database Redesign – General Questions

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

A. Correlated subqueries only
B. EXISTS/NOT EXISTS expressions only
C. Both of the above are helpful
D. None of the above are helpful.

Correct Answer:  C. Both of the above are helpful
Advertisement

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

A. MODIFY TABLE TableName DROP COLUMN ColumnName
B. MODIFY TABLE TableName DROP ColumnName
C. ALTER TABLE TableName DROP COLUMN ColumnName
D. ALTER TABLE TableName DROP ColumnName

Correct Answer:  C. ALTER TABLE TableName DROP COLUMN ColumnName
Advertisement

3. Database redesign is not terribly difficult if the:

A. database is structured.
B. database is well-designed.
C. database has no data.
D. database is relatively small.

Correct Answer:  C. database has no data.
Advertisement

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

A. RENAME TABLE
B. CHANGE TABLE
C. ALTER TABLE
D. None of the above is correct.

Correct Answer:  D. None of the above is correct.
Advertisement

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

A. data modeling.
B. database design.
C. reverse engineering.
D. None of the above is correct.

Correct Answer:  C. reverse engineering.
Advertisement

Leave A Comment?