Does the DBA have the option to confirm and implement the recommendations made by the Auto SQL Tuning feature?
Yes, the default out-of-the-box behavior of the Auto SQL Tuning feature is to display a recommendation along with validation results and let the DBA decide whether or not to accept it. The task can be easily configured to enable auto implementation of SQL profiles using the Oracle Enterprise Manager UI.