Database Redesign Changing cardinalities in a database is: is impossible to do, so a new database must be constructed and the data moved into it. a common database design task. a database design task that never occurs. a rare database design task, but does occur. is impossible to do, so a new database must be constructed and the data moved into it. a common database design task. a database design task that never occurs. a rare database design task, but does occur. 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 COLUMN ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP ColumnName ANSWER DOWNLOAD EXAMIANS APP
Database Redesign To drop a column that is used as a foreign key, first: drop the primary key. All of these drop the foreign key constraint. drop the table containing the foreign key. drop the primary key. All of these drop the foreign key constraint. drop the table containing the foreign key. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Database redesign is not terribly difficult if the: database is structured. database is well-designed. database has no data. database is relatively small. database is structured. database is well-designed. database has no data. database is relatively small. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Although creating test databases is a critical and necessary job, there are few career opportunities in this area. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS