Database Redesign Which SQL-92 standard SQL command can be used to change a table name? RENAME TABLE ALTER TABLE None of these CHANGE TABLE RENAME TABLE ALTER TABLE None of these CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Correlated subqueries are similar to a regular subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Changing cardinalities in a database is: 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. 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. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process. True False True False 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 numeric to char Changing a column data type from char to date Both of the above actions should succeed Neither of the above actions will succeed Changing a column data type from numeric to char Changing a column data type from char to date Both of the above actions should succeed ANSWER DOWNLOAD EXAMIANS APP
Database Redesign A tool that can help designers understand the dependencies of database structures is a: None of these graphical display. dependency graph. data model. None of these graphical display. dependency graph. data model. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS