nerdexam
Oracle

1Z0-497 · Question #139

Which two statements are true about shared server sessions?

The correct answer is B. User Global Area is stored in System Global Area (SGA). D. Private SQL Area is allocated from Library Cache. See the full explanation below for the reasoning.

Question

Which two statements are true about shared server sessions?

Options

  • ANo Program Global Area (PGA) is allocated for shared server processes.
  • BUser Global Area is stored in System Global Area (SGA).
  • CShared SQL Area is allocated from Program Global Area (PGA).
  • DPrivate SQL Area is allocated from Library Cache.
  • ELarge Pool is used for SQL work areas.

How the community answered

(41 responses)
  • A
    10% (4)
  • B
    73% (30)
  • C
    2% (1)
  • E
    15% (6)

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice