OCP-1Z0-052-V8.02-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

Answer: C  

答案解析：

参考： http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT1226

Shared Pool

The shared pool caches various types of program data. For example, the shared pool stores parsed SQL, PL/SQL code, system parameters, and data dictionary information. The shared pool is involved in almost every operation that occurs in the database. For example, if a user executes a SQL statement, then Oracle Database accesses the shared pool.

从下图可知：

 

The  library cache  is a shared pool memory structure that stores executable SQL and PL/SQL code.

The data dictionary is accessed so often by Oracle Database that the following special memory locations are designated to hold dictionary data:

• Data dictionary cache

  This cache holds information about database objects. The cache is also known as the row cache because it holds data as rows instead of buffers.

• Library cache

          All server processes share these caches for access to data dictionary information.

he server result cache contains the  SQL query result cache  and PL/SQL function result cache , which share the same infrastructure.