Database Redesign Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign. skeptical None of these ambivalent optimistic skeptical None of these ambivalent optimistic ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The data model that is produced from reverse engineering is: a logical model. None of these an internal model. a conceptual model. a logical model. None of these an internal model. a conceptual model. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Before any changes to database structure are attempted one should first: test any changes on a test database only. clearly understand the current structure and contents of the database only. create a complete backup of the operational database only. All of these test any changes on a test database only. clearly understand the current structure and contents of the database only. create a complete backup of the operational database only. All of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which SQL-92 standard SQL command can be used to change a table name? ALTER TABLE None of these CHANGE TABLE RENAME TABLE ALTER TABLE None of these CHANGE TABLE RENAME TABLE ANSWER DOWNLOAD EXAMIANS APP
Database Redesign To drop a column that is used as a foreign key, first: drop the table containing the foreign key. drop the foreign key constraint. All of these drop the primary key. drop the table containing the foreign key. drop the foreign key constraint. All of these drop the primary key. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign How many copies of the database schema are typically used in the redesign process? One Two Three Four One Two Three Four ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS