B, C, D
The optimizer uses hints to choose an execution plan for the statement unless prevented by some condition. (not A)
In automatic reoptimization, the optimizer changes a plan on subsequent executions after the initial execution. (C)
BCD
for F and C :
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/query-optimizer-concepts.html#GUID-FD0EC783-E77C-4F8C-A26D-C2BFDD0F4CB9
"The optimizer not only corrects itself, but also records information about the mistake, so that the database can continue to correct its estimates even after a query—and any similar query—is flushed from the shared pool."
This section is not available anymore. Please use the main Exam Page.1z0-083 Exam Questions
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.
mporislav
Highly Voted 3 years, 2 months ago_gio_
Most Recent 1 year agoScottL
1 year, 2 months agovkra
1 year, 4 months agoRinD
3 years, 2 months agoRinD
3 years, 2 months ago