Which two tasks would you perform to test the new stati…

You want to generate statistics for new objects added to an OLTP application without affecting old statistics and
the sessions that currently use them.
Which two tasks would you perform to test the new statistics? (Choose two.)

You want to generate statistics for new objects added to an OLTP application without affecting old statistics and
the sessions that currently use them.
Which two tasks would you perform to test the new statistics? (Choose two.)

A.
Set the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the session.

B.
Set the STALE_PERCENT statistics preference to zero and then gather statistics.

C.
Set the PUBLISH statistics preference to FALSE and then gather statistics.

D.
Use the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the current
statistics.

E.
Set the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting old statistics.



Leave a Reply 0

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