Partitioned Tables   «Prev  Next»

Table Partitioning Advantages - Quiz

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

1. Which table attribute is not directly changed by enabling partitioning?
Please select the best answer.
  A. Supported column datatypes
  B. Performance (for many large-table access patterns)
  C. Maintenance (partition-level operations)
  D. Availability (finer-grained maintenance windows)

2. When you partition a table, you logically divide it into partitions based on:
Please select the best answer.
  A. The underlying tablespace
  B. The underlying data files
  C. Data values (via a partition key)
  D. The sort order of the data

3. Which statement best describes how partitioning affects SQL access and maintenance?
Please select the best answer.
  A. SQL statements are usually written to target a single partition directly.
  B. Maintenance operations must be run against the complete table.
  C. Applications query the table, and Oracle can prune partitions; many maintenance tasks can be performed at the partition level.
  D. Partitioning forces both SQL statements and maintenance operations to target a single partition.