Oracle
1Z0-064 · Question #47
1Z0-064 Question #47: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #47. The question stem and answer options stay visible for context.
Question
Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)
Options
- Asetting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
- Bcoding the application such that a frequently executed statement is parsed only once and
- Csetting the CURSOR_SHARING parameter to EXACT
- Davoiding the granting of privileges on objects associated with cursors during peak load
- Eenabling Automatic Memory Management and allocating at least 50% of the available memory for
- Fconfiguring shared server connections
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.