Database Redesign A regular subquery can be processed: from the bottom up. from the top down. None of these by nesting. from the bottom up. from the top down. None of these by nesting. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which SQL-92 standard SQL command can be used to change a table name? None of these RENAME TABLE ALTER TABLE CHANGE TABLE None of these RENAME TABLE ALTER TABLE CHANGE TABLE 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
Database Redesign Correlated subqueries are similar to a regular subquery. 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 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 MODIFY TABLE TableName DROP ColumnName ANSWER DOWNLOAD EXAMIANS APP
Database Redesign A correlated subquery is processed as a nested subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP