Exam 1z0-064 topic 1 question 36 discussion

Actual exam question from Oracle's 1z0-064

Question #: 36
Topic #: 1

Your database supports a DSS workload. In an application, a few complex queries that contain multiple functions and expressions are using materialized views.
You notice that some queries are performing poorly because they are not benefiting from query rewrites.
Which three actions would you take to improve the performance of queries? (Choose three.)

A. Create an SQL Tuning Set (STS) and submit as input to the SQL Access Advisor to generate recommendations about query rewrite and fast refresh for materialized views.
B. Use the DBMS_MVIEW.EXPLAIN_REWRITE procedure to analyze why a query failed to rewrite.
C. Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about improving the performance of queries.
D. Use the DBMS_ADVISOR.TUNE_MVIEW procedure to get recommendations about rewriting materialized views.
E. Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query rewrite with materialized views.

Show Suggested Answer

Suggested Answer: ACE 🗳️

by adz07 at Jan. 29, 2024, 4:31 p.m.

Comments

Submit Cancel

adz07

1 year ago

i think ADE B. DBMS_MVIEW.EXPLAIN_REWRITE is only applicable from 9i to 11g C. I don't think SQL Performance Analyzer is needed for this - SQL Performance Analyzer enables you to assess the impact of system changes on the response time of SQL statements.

upvoted 1 times

...

Exam 1z0-064 All Questions

View all questions & answers for the 1z0-064 exam

Exam 1z0-064 topic 1 question 36 discussion

Comments

adz07

SY0-701