Sorting Operations   «Prev  Next»

Sorting Tuning Techniques - Quiz

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

1. What was listed as the main drawback of the sort_area_size parameter?
Please select the best answer.
  A. The space in sort_area_size memory is allocated for all connected users, regardless of their sorting needs.
  B. The sort_area_size parameter cannot be used to reduce disk sorts.
  C. The sort_area_size parameter cannot be used with the sort_direct_writes parameter.
  D. The sort_area_size parameter cannot be used with SQL GROUP BY directives.

2. Which are listed as techniques for reducing disk sorts? (Please select all that apply.)
Please select all the correct answers.
  A. Increasing sort_area_size
  B. Building new indices
  C. Using index hints
  D. Using direct sort writes

3. Which of the following are true about an Oracle temporary tablespace? (Please select all that apply.)
Please select all the correct answers.
  A. The TEMP tablespace can be used for small sorts by adjusting sort_direct_writes.
  B. The TEMP tablespace is coalesced by the SMON process.
  C. The TEMP tablespace is only used for large sorts that do not fit into sort_area_size.
  D. The TEMP tablespace is never used when sort_direct_writes is set to TRUE.