Exam 1z0-084 topic 1 question 35 discussion

Actual exam question from Oracle's 1z0-084

Question #: 35
Topic #: 1

You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true? (Choose two.)

A. The SQL Profiles as well as SQL Plan Baseline are implemented using hints, so they both generate the same plan.
B. The execution plan is the one enforced by the SQL Profile.
C. The execution plan is the one enforced by the SQL Plan Baseline.
D. The SQL Plan Baseline must be accepted in order to be used for the execution plan.
E. The conflict between the two plan stability methods results in an error.
F. The existence of two concurrent plan stability methods generates a child cursor for every execution.

Show Suggested Answer

Suggested Answer: BD 🗳️

by krwi1 at March 18, 2025, 10:30 a.m.

Comments

Submit Cancel

217972f

5 days, 13 hours ago

Selected Answer: CD

I think CD

upvoted 1 times

...

krwi1

3 months, 4 weeks ago

Selected Answer: CD

B is wrong - SQL PROFILE is only set of hints - do not enforce the execution plan

upvoted 1 times

...