nerdexam
Oracle

1Z0-054 · Question #180

View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle. Which two can be inferred from the output? (Choose two.)

The correct answer is A. increase in the number of active sessions D. increase in the number of processes waiting for the buffer busy wait event. See the full explanation below for the reasoning.

Question

View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle. Which two can be inferred from the output? (Choose two.)

Exhibit

1Z0-054 question #180 exhibit

Options

  • Aincrease in the number of active sessions
  • Bunable to grow the database buffer cache as per demand
  • Cincrease in number of COMMITS and ROLLBACKS per second
  • Dincrease in the number of processes waiting for the buffer busy wait event

How the community answered

(48 responses)
  • A
    73% (35)
  • B
    8% (4)
  • C
    19% (9)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice