Oracle
1Z0-064 · Question #29
1Z0-064 Question #29: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.
Question
Which three actions should you perform to reduce shared pool fragmentation and avoid the "ORA-04031: unable to allocate .... bytes of shared memory" error for the shared pool? (Choose three.)
Options
- AConfigure the Server Result Cache.
- BConfigure shared server mode.
- CIdentify the packages or procedures that are causing the "ORA-04031: unable to allocate ....
- DUse DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and
- EUse more anonymous procedures.
- FStandardize the type, size, and naming conventions for bind variables and spacing conventions
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.