Which SQL-92 standard SQL command can be used to change a table name? None of these ALTER TABLE CHANGE TABLE RENAME TABLE TRUE ANSWER : ? YOUR ANSWER : ?
The data model produced from the reverse engineering process is a true logical model. False True TRUE ANSWER : ? YOUR ANSWER : ?
Database redesign is not terribly difficult if the: database is relatively small. database has no data. database is structured. database is well-designed. TRUE ANSWER : ? YOUR ANSWER : ?
Although creating test databases is a critical and necessary job, there are few career opportunities in this area. False True TRUE ANSWER : ? YOUR ANSWER : ?
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process. True False TRUE ANSWER : ? YOUR ANSWER : ?
What SQL command can be used to delete columns from a table? ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName TRUE ANSWER : ? YOUR ANSWER : ?
Typically, there should be at least two different copies of the database schema used in the redesign process. False True TRUE ANSWER : ? YOUR ANSWER : ?
What SQL command can be used to add columns to a table? MODIFY TABLE TableName ADD ColumnName ALTER TABLE TableName ADD COLUMN ColumnName MODIFY TABLE TableName ADD COLUMN ColumnName ALTER TABLE TableName ADD ColumnName TRUE ANSWER : ? YOUR ANSWER : ?
If a database is built correctly the first time, it will not have to be redesigned. False True TRUE ANSWER : ? YOUR ANSWER : ?
The SQL-92 command to change a table name is RENAME TABLE. False True TRUE ANSWER : ? YOUR ANSWER : ?