READ Free Dumps For Oracle- 1z0-052

Question ID 21862	You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value. Which action would help to use the previous set of statistics on the objects?
Option A	Restore statistics from statistics history.
Option B	Reduce the optimizer statistics retention period by 2 days.
Option C	Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.
Option D	Reduce the Automatic Workload Repository (AWR) retention period by 2 days.
Correct Answer	A

Explanation

Question ID 21863	Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
Option A	An SPFILE is a binary file
Option B	An SPFILE cannot reside on a client
Option C	An SPFILE cannot contain static parameters
Option D	An SPFILE can store changes persistently across instance restarts
Option E	An SPFILE can be read by the database server, but it is not written to by the server
Option F	An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database
Correct Answer	A,B,D

Explanation

Previous-Page 1 2 3 4 5 6 7 8 9. . . 14 15 Next-Page

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