Database Redesign Before any changes to database structure are attempted one should first: 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 clearly understand the current structure and contents of the database only. test any changes on a test database only. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following SQL statements are helpful in database redesign? None of these Correlated subqueries only Both of the above are helpful EXISTS/NOT EXISTS expressions only None of these Correlated subqueries only Both of the above are helpful EXISTS/NOT EXISTS expressions only ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Reverse engineering is the process of reading a database schema and producing a data model from that schema. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign. None of these ambivalent skeptical optimistic None of these ambivalent skeptical optimistic ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following modifications may not succeed? Both of the above actions should succeed Neither of the above actions will succeed Changing a column data type from char to date Changing a column data type from numeric to char Both of the above actions should succeed Neither of the above actions will succeed Changing a column data type from char to date Changing a column data type from numeric to char ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS