The _____ must be set large enough to permit as many data requests to be serviced from cache as possible.
A) data cache
B) SQL cache
C) sort cache
D) optimizer mode

Question

Quizplus · Accepted Answer

The statement refers to the data cache, so option A is the best choice. The SQL cache stores query execution plans, not data. The sort cache stores the results of sorting operations, which is not relevant to the statement. The optimizer mode refers to the rules used by the query planner to optimize queries, which is also not directly related to the statement.

The _____ Must Be Set Large Enough to Permit as Many