nerdexam
Oracle

1Z0-054 · Question #210

1Z0-054 Question #210: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #210. The question stem and answer options stay visible for context.

Question

You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the Top 5 Timed Events for your database. Which two options describe what these wait events indicate? (Choose two.)

Options

  • ALatch:cache buffer LRU chains - indicates excessive block replacement
  • BLatch:cache buffer LRU chains - indicates insufficient size of application cursor cache
  • CLatch:cache buffer chains - indicates inefficient SQL that accesses many blocks repeatedly
  • DLatch:cache buffer chains - indicates that there are several sessions waiting for a buffer that is

Unlock 1Z0-054 to see the answer

You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-054 Practice