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 Before any changes to database structure are attempted one should first: create a complete backup of the operational database only. clearly understand the current structure and contents of the database only. test any changes on a test database only. All of these create a complete backup of the operational database only. clearly understand the current structure and contents of the database only. test any changes on a test database only. All of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The data model produced from the reverse engineering process is a true logical model. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The NOT EXISTS keyword will be true if: all rows in the subquery fail the condition. both of these two conditions are met. neither of these two conditions is met. any row in the subquery meets the condition. all rows in the subquery fail the condition. both of these two conditions are met. neither of these two conditions is met. any row in the subquery meets the condition. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The data model that is produced from reverse engineering is: a conceptual model. None of these a logical model. an internal model. a conceptual model. None of these a logical model. an internal model. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Adding null columns to a table is straightforward. False True False True ANSWER DOWNLOAD EXAMIANS APP