AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-050





Question ID 1811

You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SHI, 'CUSTOMERS', 'PUBLISH'.'false'); SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?
 

Option A

A.    The statistics are stored in the pending statistics table in the data dictionary.
 

Option B

B.    The statistics are treated as the current statistics by the optimizer for all sessions.

 

Option C

C.    The statistics are treated as the current statistics by the optimizer for the current sessions only.
 

Option D

D.    The statistics are temporary and used by the optimizer for all sessions until this session terminates.

Correct Answer A
Explanation


Question ID 1812

The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?

Option A

A.    to prevent the creation of an excessive number of scheduler job classes
 

Option B

B.    to allow the Automated Maintenance Tasks to use system resources without any restriction

 

Option C

C.    to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
 

Option D

D.    to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

Correct Answer D
Explanation

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