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

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?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Philippe

Philippe

Java classes should go to the java pool so why 4?