Table Partitioning Advantages - Quiz Explanation
The correct answers are indicated below, along with the text that explains the correct answers.
1.
Which area of Oracle functionality is not affected by partitioned tables?
Please select the best answer.
A.
Datatypes allowed
B.
Performance
C.
Maintenance
D.
Availability
Answer A is correct.
Partitioning affects performance, maintenance, and availability of your Oracle database, but does not affect the types of data allowed in the database.
2.
When you partition a table, you do which of the following?
Please select the best answer.
A.
Divide it into separate parts based on the underlying tablespace
B.
Divide it into separate parts based on the underlying data files
C.
Divide it into separate parts based on the data values
D.
Divide it into separate parts based on the sort order of the data
Answer C is correct.
Although you can assign partitions to tablespaces, the implementation of a partition is based on the data values in the table.
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.