Oracle
1Z0-054 · Question #157
1Z0-054 Question #157: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #157. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the partial output from the following query in an online transaction processing (OLTP) database: SQL>SELECT intsize_csec,metric_name,value, metric_unit FROM v$sysmetric; Which two conclusions can you draw about the database from these metrics? (Choose two.)
Exhibit
Options
- AThe buffer cache is inadequately sized for the workload.
- BVery few executions of SQL statements resulted in reparsing.
- CThere were no multipass executions in the Program Global Area (PGA).
- DThe database spends more time in wait events in comparison to statement processing.
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.