The _____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.
A) data
B) SQL
C) sort
D) optimizer

Question

Quizplus · Accepted Answer

The sort cache is used as a temporary storage area for sorting and grouping operations, as well as for index-creation functions. It helps to optimize query performance by reducing the amount of disk I/O required for sorting and grouping. The data cache is used for caching frequently accessed data pages and the SQL cache is used for caching frequently used SQL statements. The optimizer is responsible for generating efficient execution plans for SQL statements.

The _____ Cache Is Used as a Temporary Storage Area