Which two statements are true regarding the SQL Repair Advisor?

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

A.
The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

B.
The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

C.
The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

D.
The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.



Leave a Reply 0

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