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."
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 2 years, 9 months ago_gio_
Most Recent 7 months agoScottL
9 months, 1 week agovkra
11 months, 2 weeks agoRinD
2 years, 9 months agoRinD
2 years, 9 months ago