Sorting Operations   «Prev  Next»

Oracle Sorting Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. When does Oracle determine whether it will perform a disk or in-memory sort?
Please select the best answer.
  A. When it parses the SQL query
  B. When it prepares the execution plan
  C. Prior to retrieving the data rows
  D. After retrieving the data rows

2. What are common conditions that cause unnecessary sorting? (Please select all that apply.)
Please select all the correct answers.
  A. Joining tables without a WHERE clause
  B. Performing a sub-query
  C. Failing to define enough indices
  D. Joining more than three tables together

3. What was listed as an SQL directive that will invoke a sort (Please select all that apply.)
Please select all the correct answers.
  A. ORDER BY
  B. USING
  C. GROUP BY
  D. EXISTS