Database Redesign Before any changes to database structure are attempted one should first: clearly understand the current structure and contents of the database only. create a complete backup of the operational database only. test any changes on a test database only. All of these clearly understand the current structure and contents of the database only. create a complete backup of the operational database only. test any changes on a test database only. All of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign A tool that can help designers understand the dependencies of database structures is a: None of these dependency graph. graphical display. data model. None of these dependency graph. graphical display. data model. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following modifications may not succeed? Changing a column data type from numeric to char Neither of the above actions will succeed Changing a column data type from char to date Both of the above actions should succeed Changing a column data type from numeric to char Neither of the above actions will succeed Changing a column data type from char to date Both of the above actions should succeed ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The data model produced from the reverse engineering process does not include intersection table data. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The NOT EXISTS keyword will be true if any row in the subquery meets the condition. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS