What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?
A.
You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.
B.
After a SQL Profile is created, it will then run efficiently for the life of the database.
C.
The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.
D.
You can have only one SQL Profile active at one time for a single SQL statement.
E.
You need Oracle Database 12c or later to use SQL Profiles.
F.
SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack is licensed
AE
SQL Profiles are one part the exciting Automatic SQL Tuning feature rolled out with version 11g. This feature can automatically generate and implement SQL improvments at the discretion of the administrator.
E is incorrect
AD