Database Redesign Which SQL-92 standard SQL command can be used to change a table name? CHANGE TABLE None of these RENAME TABLE ALTER TABLE CHANGE TABLE None of these RENAME TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Database redesign is especially difficult if the database has no data. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign How many copies of the database schema are typically used in the redesign process? Four Two Three One Four Two Three One ANSWER DOWNLOAD EXAMIANS APP
Database Redesign A regular subquery can be processed: None of these from the bottom up. by nesting. from the top down. None of these from the bottom up. by nesting. from the top down. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign To drop a column that is used as a foreign key, first: All of these drop the table containing the foreign key. drop the primary key. drop the foreign key constraint. All of these drop the table containing the foreign key. drop the primary key. drop the foreign key constraint. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign What SQL command can be used to delete columns from a table? MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP COLUMN ColumnName ANSWER DOWNLOAD EXAMIANS APP