Exam 1z0-064 topic 1 question 16 discussion

Actual exam question from Oracle's 1z0-064

Question #: 16
Topic #: 1

You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics for objects accessed by the query and test query performance with the new statistics without affecting other sessions connected to the instance.
The STALE_PERCENT statistic preference is set to a default value and the STATISTICS_LEVEL parameter is set to TYPICAL.
Which two actions would you take to accomplish the task? (Choose two.)

A. Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.
B. Set the STATISTICS_LEVEL parameter to ALL for the instance.
C. Set the INCREMENTAL preference to TRUE, and then gather statistics.
D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.
E. Set the PUBLISH statistic preference to FALSE, and then gather statistics.
F. Set the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.

Show Suggested Answer

Suggested Answer: BE 🗳️

by adz07 at Dec. 14, 2023, 5:32 p.m.

Comments

Submit Cancel

adz07

1 year, 1 month ago

D and E?

upvoted 1 times

...

Exam 1z0-064 All Questions

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

Exam 1z0-064 topic 1 question 16 discussion

Comments

adz07

SY0-701