Home » Oracle » 1z0-067 v.2 » What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
A. statistics recommendations
B. SQL profile recommendations
C. SQL statement restructure recommendations
D. creation of materialized views to improve query performance
Correct Answer: B
Explanation/Reference:
Explanation:
Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed: … During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE
Download Printable PDF. VALID exam to help you PASS.
|
|