Database Redesign - General Questions (3)

17.

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

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

18.

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.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

19.

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

20.

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.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.