Database Redesign What SQL command can be used to delete columns from a table? ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The SQL-92 command to change a table name is RENAME TABLE. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following modifications may not succeed? Neither of the above actions will succeed Both of the above actions should succeed Changing a column data type from numeric to char Changing a column data type from char to date Neither of the above actions will succeed Both of the above actions should succeed Changing a column data type from numeric to char Changing a column data type from char to date ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The data model that is produced from reverse engineering is: None of these an internal model. a logical model. a conceptual model. None of these an internal model. a logical model. a conceptual model. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign It is not easy to build a database correctly the first time. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Database redesign is not terribly difficult if the: database is relatively small. database is structured. database has no data. database is well-designed. database is relatively small. database is structured. database has no data. database is well-designed. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS