Free 1Z0-117 Web TestEngine Demo

Q11 Single choice

You notice some performance degradation for a high-load SQL statement in your database. After investigations, you run the SQL Tuning Advisor, which recommends a SQL Profile. You accept the profile recommendation resulting in a new, tuned execution plan for the statement.

Your database uses SQL plan management and a SQL plan baseline exists for this SQL statement.

Which statement is true?

A
The database adds the tuned plan to the SQL plan baseline as a nonfixed plan.
B
The database adds the tuned plan to the SQL plan baseline as a fixed plan.
C
The optimizer uses the new tuned plan only when a reproducible fixed plan is present.
D
The created SQL profile will continuously adapt to all changes made to the database, the object, and to the system statistics over an extended length of time.

1Z0-117 Web TestEngine demo