Oracle
1Z0-064 · Question #45
1Z0-064 Question #45: Real Exam Question with Answer & Explanation
The correct answer is A. Mutex contention in the library cache will be reduced. C. Hard parses will be reduced for the queries. D. The optimizer will use bind peeking and subsequent execution of the queries will always generate E. The optimizer will generate the same plan for all bind values if no histograms exist on the. See the full explanation below for the reasoning.
Question
You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE clause, causing a large number of hard parses to occur. Which four statements would be true if you use bind variables for these queries? (Choose four.)
Options
- AMutex contention in the library cache will be reduced.
- BThe optimizer will use one parent cursor and one child cursor for each SQL statement with
- CHard parses will be reduced for the queries.
- DThe optimizer will use bind peeking and subsequent execution of the queries will always generate
- EThe optimizer will generate the same plan for all bind values if no histograms exist on the
- FThe optimizer will use bind peeking and use the literal value to determine the execution plan for
Community Discussion
No community discussion yet for this question.