Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?

Which statement most accurately describes the implementation of a SQL Access Advisor
recommendation?

Which statement most accurately describes the implementation of a SQL Access Advisor
recommendation?

A.
SQL Access Advisor recommendations are automatically implemented.

B.
Individual SQL Access Advisor recommendations can be scheduled for implementation.

C.
All SQL Access Advisor recommendations for a specific task must be implemented at the
same time.

D.
SQL Access Advisor recommendations are automatically scheduled for implementation
during the maintenance window.

E.
None of the above.

Explanation:
Implementing the SQL Access Advisor Recommendations (link)
A SQL Access Advisor recommendation can range from a simple suggestion to a complex
solution that requires partitioning a set of existing base tables and implementing a set of

database objects such as indexes, materialized views, and materialized view logs. You can
select the recommendations for implementation and schedule when the job should be
executed.



Leave a Reply 0

Your email address will not be published. Required fields are marked *