ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-053 All Questions

View all questions & answers for the 1z0-053 exam
Go to Exam

Exam 1z0-053 topic 13 question 40 discussion

Actual exam question from Oracle's 1z0-053
Question #: 40
Topic #: 13
[All 1z0-053 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
You can run SQL Repair Advisor through the EM Support Workbench when an incident raised.
Or You run the SQL Repair Advisor by creating and executing a diagnostic task using the DBMS_SQLDIAG. CREATE_DIAGNOSIS_TASK and DBMS_SQLDIAG. respectively. The SQL Repair Advisor first reproduces the critical error and then tries to produce a workaround in the form of SQL patch.
by [deleted] at April 4, 2025, 8:13 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel