Multiple choice technology databases

This reduces the processing time used for parsing and execution

  1. buffer cache

  2. library cache

  3. data dictionary cache

  4. none of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The library cache, a component of the Shared Pool, stores parsed SQL statements, execution plans, and PL/SQL code. Reusing these cached objects eliminates parsing overhead, reducing query processing time.

Keep practicing — related questions