Partitioned Tables   «Prev  Next»

Table Partitioning Advantages - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

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

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


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.

Correct answers:

Your Score: 0