3. |
Which of the following descriptions about the effect of partitioning on SQL statements and maintenance operations are true?
Please select the best answer.
|
|
A. |
An SQL statement is usually directed at the complete table and a maintenance operation is usually directed at the complete table.
|
|
B. |
An SQL statement is usually directed at a single partition and a maintenance operation is usually directed at the complete table.
|
|
C. |
An SQL statement is usually directed at the complete table and a maintenance operation is usually directed at a single partition.
|
|
D.
|
An SQL statement is usually directed at a single partition and a maintenance operation is usually directed at a single partition.
|
|
Answer C is correct.
An SQL statement is usually directed at the complete table and the Oracle database routes it to the appropriate partition or partitions. A maintenance operation is frequently done for a single partition to reduce the overall time needed for the operation to complete.
|