Exam 1z0-062 topic 1 question 260 discussion

Actual exam question from Oracle's 1z0-062

Question #: 260
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: D 🗳️

by hggz at Aug. 27, 2020, 8:19 a.m.

Comments

Submit Cancel

dfabac

2 years, 12 months ago

Selected Answer: D

The database administrator can configure an optional memory area called the large pool to provide large memory allocations for: Session memory for the shared server and the Oracle XA interface (used where transactions interact with more than one database) I/O server processes Oracle backup and restore operations Parallel execution message buffers, if the initialization parameter PARALLEL_AUTOMATIC_TUNING is set to true (otherwise, these buffers are allocated to the shared pool)

upvoted 1 times

...

hggz

4 years, 9 months ago

Correct: https://docs.oracle.com/cd/B10501_01/server.920/a96524/c08memor.htm

upvoted 3 times

...