Prev Question
Next Question

Instead of a database automatically publishing statistics when statistics collection ends, you want to test
queries a satisfactory result before they are made available to the entire database. Which would you
configure for that to occur?

A. Set OPTIMIZER_USE_PENDING_STATISTICS to TRUE.

B. Set AUTO_UPDATE_STATISTICS to FALSE.

C. Use a HOLD HINT in the SQL.

D. Set AUTOMATIC_WORKLOAD_REPOSITORY_COLLECTION to PAUSE.

Explanation:

Prev Question
Next Question

Leave a Reply

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