Managing Tables   «Prev  Next»

Altering and Dropping tables - Quiz

Each question is worth one point. Select the best answer for each question.
1. Which action is not normally done using the ALTER TABLE command?
Please select the best answer.
  A. Add a column to a table
  B. Drop a column from a table
  C. Rename a table
  D. Change the storage characteristics of a table

2. When you DROP a table in Oracle, what is affected?
Please select the best answer.
  A. Just the table structure
  B. The table structure and the data it contains
  C. Just the data contained in the table
  D. The table structure, the data it contains, and dependent objects such as indexes, constraints, and triggers

3. How does dropping a table affect other database objects?
Please select the best answer.
  A. Dropping a table never affects other database objects.
  B. Dropping a table can affect other database objects.
  C. Dropping a table can affect other database objects, but Oracle always warns you in advance.
  D. You cannot drop a table in modern Oracle databases.