Oracle Database 12c: Installation and Administration — Question 173

Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)

Answer options

• A. Automatic Database Diagnostic Monitor
• B. optimizer statistics gathering
• C. SQL Access Advisor
• D. Segment Advisor
• E. Automatic SQL Tuning Advisor

Correct answer: B, D, E

Explanation

The correct answers B, D, and E are part of the automated maintenance tasks that help in optimizing database performance. Option A, the Automatic Database Diagnostic Monitor, is not run by default in this context, and option C, SQL Access Advisor, does not fall under the automated maintenance tasks performed by default.