Partitioned Tuning   «Prev  Next»

Oracle Partitioning - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which are performance benefits of partitioned tables?
Please select all the correct answers.
  A. The ability to restrict an SQL query to one or more relevant partitions
  B. The ability to support parallel operations against table partitions
  C. The ability to bypass indexes in all queries
  D. The ability to address rows by OID

2. What type of application would most likely benefit from a partitioned table with local partitioned indexes?
Please select the best answer.
  A. A very large database with OLTP application processing
  B. A medium-sized database with OLTP applications
  C. A medium-sized database with DSS application processing
  D. A very large database with DSS application processing

3. Which of the following are valid ways to partition an Oracle table?
Please select all the correct answers.
  A. Hash partitioning
  B. Range partitioning
  C. List partitioning
  D. Composite partitioning, such as range-hash or range-list

4. From a DBA maintenance perspective, what partitioning feature is most attractive to the DBA?
Please select the best answer.
  A. The ability to restrict an SQL query with the PARTITION clause
  B. The ability to reorganize a partition independently from the whole table
  C. The ability to create read-only partitions
  D. The ability to bypass global index processing