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 The process of reading a database schema and producing a data model from that schema is known as: data modeling. None of these database design. reverse engineering. data modeling. None of these database design. reverse engineering. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Typically, there should be at least two different copies of the database schema used in the redesign process. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign What SQL command can be used to delete columns from a table? MODIFY TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which is not true of a correlated subquery? They are very similar to a regular subquery. They can be used to verify functional dependencies. The processing of the SELECT statements is nested. EXISTS/NOT EXISTS is a form of a correlated subquery. They are very similar to a regular subquery. They can be used to verify functional dependencies. The processing of the SELECT statements is nested. EXISTS/NOT EXISTS is a form of a correlated subquery. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The use of the double NOT EXISTS can be used to find rows that do not match some specified condition. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS