RelationalDBDesign RelationalDBDesign 


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 with the PARTITION clause
  B. The ability to invoke intra-partition parallelism
  C. The ability to bypass indexes
  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 ways to partition a table?
Please select all the correct answers.
  A. By hash value
  B. By column range value
  C. By index column value
  D. By a composite value of hash and range

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