Oracle
1Z0-497 · Question #73
Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQLAccess Advisor? (Choose two.)
The correct answer is B. SQLTuning Advisor considers the impact of new indexes on both queries and DML operations. C. SQLTuning Advisor considers the impact of the newindexeson both queries and DML operations. See the full explanation below for the reasoning.
Question
Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQLAccess Advisor? (Choose two.)
Options
- ASQLTuning Advisor considers the impact of the indexes only queries.
- BSQLTuning Advisor considers the impact of new indexes on both queries and DML operations.
- CSQLTuning Advisor considers the impact of the newindexeson both queries and DML operations.
- DSQLTuning Advisor considers the impact of the indexes on only data manipulation language(DML)
How the community answered
(21 responses)- A14% (3)
- B81% (17)
- D5% (1)
Community Discussion
No community discussion yet for this question.