Which component of the SGA contains the parsed SQL code?

  1. Buffer cache

  2. Dictionary cache

  3. Library cache

  4. Parse cache


Correct Option: C
Explanation:

To answer this question, the user needs to have knowledge of Oracle's System Global Area (SGA) and its components. The SGA is a shared memory area that stores data and control information for Oracle database instances. The components of the SGA include the buffer cache, the shared pool, and the large pool.

The parsed SQL code is stored in the Library Cache, which is part of the shared pool. The Library Cache is a part of the SGA that stores shared SQL and PL/SQL areas. These areas contain parsed and executable forms of SQL and PL/SQL statements.

Therefore, the correct answer to this question is:

The Answer is: C. Library cache

Find more quizzes: