1Z0-052 · Question #197
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…
The correct answer is C. 1,3, and 4. The Shared Pool contains the Data Dictionary Cache, Library Cache, and (with configuration) the Result Cache, but the PGA holds runtime areas and redo structures hold transaction reconstruction data.
Question
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?
Options
- A1 and 2
- B2 and 5
- C1,3, and 4
- D3,4 and 5
- E1,2,3 and 4
How the community answered
(25 responses)- C96% (24)
- E4% (1)
Why each option
The Shared Pool contains the Data Dictionary Cache, Library Cache, and (with configuration) the Result Cache, but the PGA holds runtime areas and redo structures hold transaction reconstruction data.
Point 2 (runtime area for DML/DDL statements) belongs to the Program Global Area (PGA), not the Shared Pool.
Point 5 (information to reconstruct transaction changes) is stored in undo segments and the redo log buffer, not in the Shared Pool.
Point 1 (metadata about schema objects) maps to the Data Dictionary Cache in the Shared Pool, point 4 (executable SQL cursors, PL/SQL programs, Java classes) maps to the Library Cache, and point 3 (SQL query and PL/SQL function results) maps to the Result Cache - all residing in the Shared Pool when properly configured via parameters such as RESULT_CACHE_MODE.
Point 5 (transaction reconstruction data) resides in undo and redo structures outside the Shared Pool, so it does not belong in this set.
Point 2 (DML/DDL runtime area) is a PGA component, not a Shared Pool component, making this set incorrect.
Concept tested: Oracle Shared Pool subcomponents and memory architecture
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html
Topics
Community Discussion
No community discussion yet for this question.