Multiple choice

Which of the following is correct about 'Library cache' in Oracle database?

  1. It is responsible for storing the shared SQL statements and execution steps for that.

  2. It is used to enhance the amount of memory needed and the processing-time used for parsing and execution planning.

  3. It has user information and user privileges.

  4. In this cache, the information on space is allocated and used for schema objects.

  5. In this cache, the information is managed as per the specific execution plan.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The library cache stores shared SQL, caching the parse tree and the execution plan for every unique SQL statement.

Keep practicing — related questions