Oracle
1Z0-054 · Question #56
1Z0-054 Question #56: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #56. The question stem and answer options stay visible for context.
Question
Examine the output of the following query: SQL> SELECT c.name,a.addr,a.gets,a.misses,a.sleeps, 2 a.immediate_gets,a.immediate_misses,b.pid 3 FROM v$latch a, v$latchholder b, v$latchname c 4 WHERE a.addr = b.laddr(+) and a.latch# = c.latch# 5 AND c.name LIKE '&latch_name%' ORDER BY a.latch#; LATCH NAME ADDR GETS MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES ---- -------- -------- -------- ------- ------ -------------- shared pool 20016544 8520540 14112 3137 0 0 Which two conclusions can you draw from this? (Choose two.)
Options
- AThe latch was requested in no wait mode.
- BThe latch was requested in willing-to-wait mode.
- CThe shared pool operations to allocate and free memory in it caused the misses.
- DAutomatic Memory Management is not enabled because the IMMEDIATE_GETS and
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.