Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)
В,C,D correct:
B. SQL Plan Baselines: https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL615
"For example, a SQL statement with bind variables whose values result in different selectivities may have several optimal plans. Creating a materialized view or an index or repartitioning a table may make current plans more expensive than other plans."
C. Adaptive Cursor Sharing: https://docs.oracle.com/database/121/TGSQL/tgsql_cursor.htm#TGSQL-GUID-42432DFE-D56A-4B9A-8FCF-94FB86012AFC
"The adaptive cursor sharing feature enables a single statement that contains bind variables to use multiple execution plans. Cursor sharing is "adaptive" because the cursor adapts its behavior so that the database does not always use the same plan for each execution or bind variable value."
D. Bind variable used in a SQL statement
ACE is the correct answer. d is wrong When using bind variables there will be only one cursor and one execution plan in the Shared Pool regardless of the value being send to the bind variable. If the bind variable is selecting from a column which is highly skewed then the execution plan may not be optimal.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
verratti
Highly Voted 5 years agoluizyto
Most Recent 2 years, 4 months agoTuxBingo
3 years, 10 months agohggz
4 years, 11 months agohggz
4 years, 6 months agoverratti
5 years agosoniat
3 years, 11 months ago