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.
|