Reduce Disk I/O | Process   «Prev  Next»

Reducing Chained Rows - Exercise

Oracle block concepts

Objective: Match Oracle block concepts with corresponding definitions

Match Items

Match items in the left column with the items in the right column. If you do not have Java active in your browser or are behind a firewall that does not allow Java applets, you will not be able to complete this exercise. If you do not see the applet below, click the Submit button to continue with the course. You will receive full credit for this exercise.

In the left column below are 4 terms and their corresponding definitions in the right column. Click a term in the left column, then click the definition in the right column to make a match. When you have all of the terms and their definitions matched, click the Done button to see whether or not you've matched the terms correctly. Green lines mean the match is correct, red lines mean the match is incorrect. If you didn't get the matches right the first time, click Clear to erase your matches and try again. When you complete the exercise, click the Submit button to see the correct answers.

Exercise Scoring

You will receive 3 points for this exercise. The exercise is auto-scored. When you complete the exercise, click the OK, I'm Done button to receive full credit.
  1. RAW datatype
  2. Parallel CTAS
  3. CTAS with index hint
  4. Clustering factor
  1. Requires a full-table scan
  2. The measure of index to table sequence
  3. May cause chained rows
  4. Reads the table in index order