Which three are true about the large pool for an Oracle database instance that supports shared server connections?

The correct answer is A. Allocates memory for RMAN backup and restore operations C. Contains a cursor area for storing runtime information about cursors E. Contains a hash area performing hash joins of tables. Allocates memory for shared and private SQL areas: NO. Оnly for private SQL AREA (when using shared server). Shared SQL area ALLWAYS!!!! in shared pool HASH area in a share server mode is located in LArge pool like a sort area.

New Features for Database Infrastructure and Architecture

Question

Options

AAllocates memory for RMAN backup and restore operations
BAllocates memory for shared and private SQL areas
CContains a cursor area for storing runtime information about cursors
DContains stack space
EContains a hash area performing hash joins of tables

How the community answered

(24 responses)

A
88% (21)
B
8% (2)
D
4% (1)

Explanation

Allocates memory for shared and private SQL areas: NO. Оnly for private SQL AREA (when using shared server). Shared SQL area ALLWAYS!!!! in shared pool HASH area in a share server mode is located in LArge pool like a sort area.

Topics

#large pool#shared server#RMAN memory#cursor area

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice