Examine the parameters set for your database instance:

You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in the SQL Plan Management Base. Which action is taken by the optimizer? (Choose the best answer.)

Question

Examine the parameters set for your database instance:

You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in the SQL Plan Management Base. Which action is taken by the optimizer? (Choose the best answer.)

Accepted Answer

B. It adds the newly generated plan as enabled and accepted.

Answer

A. It adds the newly generated plan as an accepted but non-fixed plan.

Answer

C. It adds the newly generated plan as enabled but not accepted.

Answer

D. It adds the newly generated plan as a fixed plan, which will be used each time the SQL statement

Examine the parameters set for your database instance: You notice that for one particular SQL statement, the optimizer generates a new better plan than the plans in the SQL Plan Management Base…

Question

Exhibit

Options

How the community answered

Community Discussion