Oracle
1Z0-054 · Question #87
1Z0-054 Question #87: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the content of the V$PGA_TARGET_ADVICE_HISTOGRAM view. What would you infer from this?
Exhibit
Options
- AIf the PGA size is set to 4 MB, then all the work areas would execute in optimal mode.
- BIf the PGA size is doubled, then all the work areas that are less than 2 MB would execute in
- CIf the PGA size is set to 32 MB, then the number of work areas would reduce. So it is the
- DIf the size of the Program Global Area (PGA) is set to more than 64 MB, then all the work areas
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.