nerdexam
Oracle

1Z0-054 · Question #97

View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view. You executed the following command to increase the size of the Large Pool: SQL> ALTER SYSTEM SET large_pool_size=8M; System…

The correct answer is D. Default Buffer Cache. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view. You executed the following command to increase the size of the Large Pool:

SQL> ALTER SYSTEM SET large_pool_size=8M; System altered. Which component would shrink to increase the size of the Large Pool?

Exhibit

1Z0-054 question #97 exhibit

Options

  • Athe Java Pool
  • Bthe Shared Pool
  • CKEEP Buffer Cache
  • DDefault Buffer Cache

How the community answered

(30 responses)
  • A
    10% (3)
  • B
    7% (2)
  • C
    3% (1)
  • D
    80% (24)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice