RelationalDBDesign 




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 cannot be 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, you actually delete:
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 the table contains, and the indexes, constraints, and triggers associated with the table

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 lets you know in advance.
  D. You cannot drop a table in Oracle 8.
Score =
Correct answers: