Database Redesign Database redesign is not terribly difficult if the: database is relatively small. database has no data. database is well-designed. database is structured. database is relatively small. database has no data. database is well-designed. database is structured. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which SQL-92 standard SQL command can be used to change a table name? CHANGE TABLE RENAME TABLE ALTER TABLE None of these CHANGE TABLE RENAME TABLE ALTER TABLE None of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign A regular subquery can be processed: by nesting. from the top down. None of these from the bottom up. by nesting. from the top down. None of these from the bottom up. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which of the following SQL statements are helpful in database redesign? None of these Correlated subqueries only Both of the above are helpful EXISTS/NOT EXISTS expressions only None of these Correlated subqueries only Both of the above are helpful EXISTS/NOT EXISTS expressions only ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Before any changes to database structure are attempted one should first: create a complete backup of the operational database only. clearly understand the current structure and contents of the database only. test any changes on a test database only. All of these create a complete backup of the operational database only. clearly understand the current structure and contents of the database only. test any changes on a test database only. All of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Adding null columns to a table is straightforward. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS