1. Which of the following SQL statements are helpful in database redesign? A. Correlated subqueries only B. EXISTS/NOT EXISTS expressions only C. Both of the above are helpful D. None of the above are helpful Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
2. What SQL command can be used to delete columns from a table? A. MODIFY TABLE TableName DROP COLUMN ColumnName B. MODIFY TABLE TableName DROP ColumnName C. ALTER TABLE TableName DROP COLUMN ColumnName D. ALTER TABLE TableName DROP ColumnName Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
3. Database redesign is not terribly difficult if the: A. database is structured. B. database is well-designed. C. database has no data. D. database is relatively small. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
4. Which SQL-92 standard SQL command can be used to change a table name? A. RENAME TABLE B. CHANGE TABLE C. ALTER TABLE D. None of the above is correct Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option D No explanation is given for this question Let's Discuss on Board
5. The process of reading a database schema and producing a data model from that schema is known as: A. data modeling. B. database design. C. reverse engineering. D. None of the above is correct. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board