Oracle Database 12c: Installation and Administration — Question 142

Your database instance has Automatic Memory Management enabled and supports shared server connections.
Examine the following:
1. Parallel execution messages and control structures
2. Local variables for a process
3. Security and resource usage information
4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?

Answer options

• A. only 1
• B. 1, 2, and 5
• C. 1, 2, 3, and 5
• D. 1, 2, and 4

Correct answer: D

Explanation

The correct answer is D because the large pool is used for parallel execution messages and control structures (1), local variables for a process (2), and runtime memory values related to SQL execution (4). Options A, B, and C include incorrect items that are not allocated from the large pool, such as security and resource usage information (3) and SQL execution work areas (5).