Oracle 11G OCP 1Z0-052 14

（14）These are points that describe the contents of different memory components:

1: Descriptive information or metadata about schema objects that are queried by using SQL statements

2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements

3: Results of SQL queries and PL/SQL functions

4: Executable forms of SQL cursors, PL/SQL programs, and Java classes

5: The information necessary to reconstruct changes made to the database by a transaction

Which of these will be stored in the Shared Pool if the necessary configurations are done?

A.1 and 2

B.2 and 5

C.  1, 3, and 4

D.  3, 4, and 5

E.  1, 2, 3, and 4

答案：（C）

解析：

1. 位于Shared Pool->Library Cache->Shared SQL Area中

2. 位于PGA中

3. 位于Shared Pool->Server Result Cache->SQL Query Result Cache和PL/SQL Function Result Cache

4. 位于Shared Pool->Shared SQL Area

5. 位于Redo Log Buffer