Database Redesign The NOT EXISTS keyword will be true if any row in the subquery meets the condition. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which SQL-92 standard SQL command can be used to change a table name? ALTER TABLE None of these CHANGE TABLE RENAME TABLE ALTER TABLE None of these CHANGE TABLE RENAME TABLE ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following SQL statements are helpful in database redesign? Both of the above are helpful EXISTS/NOT EXISTS expressions only Correlated subqueries only None of these Both of the above are helpful EXISTS/NOT EXISTS expressions only Correlated subqueries only None of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following modifications may not 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 Neither of the above actions will succeed ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Database redesign is especially difficult if the database has no data. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS