READ Free Dumps For Oracle- 1z0-117

Question ID 2621	You recently gathered statistics for a table by using the following commands:   You noticed that the performance of queries has degraded after gathering statistics. You want to use the old statistics. The optimizer statistics retention period is default. What must you do to use the old statistics?
Option A	A.    Use the flashback to bring back the statistics to the desired time.
Option B	B.    Restore statistics from statistics history up to the desired time.
Option C	C.    Delete all the statistics collected after the desired time.
Option D	D.    Set OPTIMIZER_USE_PENDING_STATISTICS to TRUE.
Correct Answer	B

Explanation

Question ID 2622	Which interpretation is correct?
Option A	A.    A new plan cannot be evolved because SYS_SQL_bbedc41f554c408 is accepted.
Option B	B.    Plan SYS_SQL_PLAN_bbdc741f554c408 will always be used by the optimizer for the query.
Option C	C.    A new plan must be evolved using the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function before it can be used.
Option D	D.    Plan SYS_SQL_bbedc741a57b5fc2 can be used by the optimizer if the cost of the query is less than plan SYS_SQL_PLAN_bbedc741f554c408.
Option E	E.    Plan SYS_SQL_PLAN_bbedc741f554c408 will not be used until it is fixed by using the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function.
Correct Answer	C

Explanation

Previous-Page 1 2... 53 54 55 56 57 58 59 60 61 Next-Page

Send email to admin@getfreedumps for new dumps request!!!