Database Redesign Changing cardinalities in a database is: is impossible to do, so a new database must be constructed and the data moved into it. a common database design task. a rare database design task, but does occur. a database design task that never occurs. is impossible to do, so a new database must be constructed and the data moved into it. a common database design task. a rare database design task, but does occur. a database design task that never occurs. 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 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 Both of the above actions should succeed ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The SQL-92 command to change a table name is RENAME TABLE. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Although creating test databases is a critical and necessary job, there are few career opportunities in this area. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which is not true of a correlated subquery? They can be used to verify functional dependencies. EXISTS/NOT EXISTS is a form of a correlated subquery. The processing of the SELECT statements is nested. They are very similar to a regular subquery. They can be used to verify functional dependencies. EXISTS/NOT EXISTS is a form of a correlated subquery. The processing of the SELECT statements is nested. They are very similar to a regular subquery. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following SQL statements are helpful in database redesign? Both of the above are helpful Correlated subqueries only None of these EXISTS/NOT EXISTS expressions only Both of the above are helpful Correlated subqueries only None of these EXISTS/NOT EXISTS expressions only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS