Database Redesign problems
- 1. What SQL command can be used to add columns to a table?
Options- A. MODIFY TABLE TableName ADD COLUMN ColumnName
- B. MODIFY TABLE TableName ADD ColumnName
- C. ALTER TABLE TableName ADD COLUMN ColumnName
- D. ALTER TABLE TableName ADD ColumnName Discuss
Correct Answer: ALTER TABLE TableName ADD ColumnName
- 2. The NOT EXISTS keyword will be true if:
Options- A. any row in the subquery meets the condition.
- B. all rows in the subquery fail the condition.
- C. both of these two conditions are met.
- D. neither of these two conditions is met. Discuss
Correct Answer: all rows in the subquery fail the condition.
- 3. A regular subquery can be processed:
Options- A. from the top down.
- B. from the bottom up.
- C. by nesting.
- D. None of the above is correct. Discuss
Correct Answer: from the bottom up.
- 4. How can you find rows that do not match some specified condition?
Options- A. EXISTS
- B. Double use of NOT EXISTS
- C. NOT EXISTS
- D. None of the above is correct. Discuss
Correct Answer: Double use of NOT EXISTS
- 5. What SQL command can be used to delete columns from a table?
Options- 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 Discuss
Correct Answer: ALTER TABLE TableName DROP COLUMN ColumnName
- 6. Which of the following SQL statements are helpful in database redesign?
Options- A. Correlated subqueries only
- B. EXISTS/NOT EXISTS expressions only
- C. Both of the above are helpful
- D. None of the above are helpful. Discuss
Correct Answer: Both of the above are helpful
- 7. A tool that can help designers understand the dependencies of database structures is a:
Options- A. dependency graph.
- B. data model.
- C. graphical display.
- D. None of the above is correct. Discuss
Correct Answer: dependency graph.
- 8. The data model that is produced from reverse engineering is:
Options- A. a conceptual model.
- B. an internal model.
- C. a logical model.
- D. None of the above is correct. Discuss
Correct Answer: None of the above is correct.
- 9. The EXISTS keyword will be true if:
Options- A. any row in the subquery meets the condition only.
- B. all rows in the subquery fail the condition only.
- C. both of these two conditions are met.
- D. neither of these two conditions is met. Discuss
Correct Answer: any row in the subquery meets the condition only.
- 10. Which SQL-92 standard SQL command can be used to change a table name?
Options- A. RENAME TABLE
- B. CHANGE TABLE
- C. ALTER TABLE
- D. None of the above is correct. Discuss
Correct Answer: None of the above is correct.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.