Database Redesign Changing cardinalities in a database is: 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. is impossible to do, so a new database must be constructed and the data moved into it. a common database design task. 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 Before any changes to database structure are attempted one should first: clearly understand the current structure and contents of the database only. test any changes on a test database only. create a complete backup of the operational database only. All of these clearly understand the current structure and contents of the database only. test any changes on a test database only. create a complete backup of the operational database only. All of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Database redesign is especially difficult if the database has no data. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign To drop a column that is used as a foreign key, first: All of these drop the foreign key constraint. drop the primary key. drop the table containing the foreign key. All of these drop the foreign key constraint. drop the primary key. drop the table containing the foreign key. 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
EXAMIANS