Oracle
1Z0-054 · Question #154
1Z0-054 Question #154: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #154. The question stem and answer options stay visible for context.
Question
Examine the following query and its output: SQL>SELECT namespace, gets, gethits, gethitratio, pins, pinhits, reloads,invalidations FROM v$librarycache WHERE namespace = 'SQL AREA'; NAMESPACE GETS GETHITS GETHITRATIO PINS PINHITS RELOADS INVALIDATIONS - -------- ----- ------- ----------- ----- ------- -------- ------------- SQL AREA 11942 2832 .237146207 65900 62486 28 118 Which two observations are correct? (Choose two.)
Options
- AAbout 24% of the parse calls were able to find a cursor to share.
- BDML locks were requested 65,900 times for objects in the SQL AREA.
- CLibrary cache misses happened 118 times because invalidations occurred due to DDL on the
- DReparsing of SQL statements before they had finished executing happened 28 times due to
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.