Database Redesign - Study Mode
[#1] Which of the following SQL statements are helpful in database redesign?
Correct Answer
(C) Both of the above are helpful
[#2] What SQL command can be used to delete columns from a table?
Correct Answer
(C) ALTER TABLE TableName DROP COLUMN ColumnName
[#3] Database redesign is not terribly difficult if the:
Correct Answer
(C) database has no data.
[#4] Which SQL-92 standard SQL command can be used to change a table name?
Correct Answer
(D) None of the above is correct
[#5] The process of reading a database schema and producing a data model from that schema is known as:
Correct Answer
(C) reverse engineering.