Partitioned Tables   «Prev  Next»

Modifying Oracle Partitions - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following modifications can you completely perform with a single ALTER TABLE command?
Please select all the correct answers.
  A. Add a partition
  B. Merge a partition
  C. Split a partition
  D. Dump data with a partition

2. Which of the following types of indexes or index partitions are marked as UNUSABLE when you truncate a partition in a table?
Please select all the correct answers.
  A. Local indexes
  B. Global partitioned indexes with a reference to the truncated table partition
  C. All partitions in a global partitioned indexes
  D. All global non-partitioned indexes


3. Which of the following statements best describes the difference between truncating a partition and dropping the partition?
Please select the best answer.
  A. Dropping a partition deletes the data from the partition, while truncating a partition drops the data and the partition structure.
  B. Truncating a partition deletes the data from the partition, while dropping a partition drops the data and the partition structure.
  C. Truncating a partition forces a local index partition to be rebuilt, while dropping a partition does not.
  D. There is no difference.