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 runtime 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
Java classes should go to the java pool so why 4?
11g R2 Source :
http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT1226
Extract:
Program Units and the Library Cache
The library cache holds executable forms of PL/SQL programs and Java classes. These items are collectively referred to as program units.
So C is correct.