Database Redesign The process of reading a database schema and producing a data model from that schema is known as: reverse engineering. database design. data modeling. None of these reverse engineering. database design. data modeling. None of these 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. ambivalent optimistic None of these skeptical ambivalent optimistic None of these skeptical ANSWER DOWNLOAD EXAMIANS APP
Database Redesign What SQL command can be used to delete columns from a table? MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP COLUMN ColumnName ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Typically, there should be at least two different copies of the database schema used in the redesign process. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following modifications may not succeed? 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 Changing a column data type from numeric to char ANSWER DOWNLOAD EXAMIANS APP
Database Redesign How can you find rows that do not match some specified condition? NOT EXISTS Double use of NOT EXISTS EXISTS None of these NOT EXISTS Double use of NOT EXISTS EXISTS None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS