nerdexam
Oracle

1Z0-043 · Question #97

Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would…

The correct answer is B. modify the PGA_AGGREGATE_TARGET initialization parameter. See the full explanation below for the reasoning.

Question

Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?

Options

  • Amodify the HASH_AREA_SIZE initialization parameter
  • Bmodify the PGA_AGGREGATE_TARGET initialization parameter
  • Cmodify the WORK_AREASIZE_POLICY initialization parameter
  • Dincrease the value of the SGA_TARGET initialization parameter
  • Eincrease the value of the SGA_MAX_SIZE initialization parameter
  • Fincrease the value of the SORT_AREA_SIZE initialization parameter

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    78% (18)
  • E
    9% (2)
  • F
    9% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice