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-117





Question ID 2595

You are administering a database supporting a DDS workload in which some tables are updated frequently but not queried often. You have SQL plan baseline for these tables and you do not want the automatic maintenance task to gather statistics for these tables regularly.
Which task would you perform to achieve this?
 

Option A

A.    Set the INCREMENTAL statistic preference FALSE for these tables.
 

Option B

B.    Set the STALE_PERCENT static preference to a higher value for these tables.
 

Option C

C.    Set the GRANULARITY statistic preference to AUTO for these tables.

 

Option D

D.    Set the PUBLISH statistic preference to TRUE for these tables.

Correct Answer B
Explanation


Question ID 2596

Your database has the OLTP_SRV service configured for an OLTP application running on a middle tier. This service is used to connect to the database by using connection pools. The application has three modules. You enabled tracing at the service by executing the following command:
SQL exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘OLTP_SRV’); What is the correct method of consolidating the trace files generated by the procedure?
 

Option A

A.    Use all trace files as input for the tkprof utility to consolidate the trace files for a module.
 

Option B

B.    Use one trace file at a time as input for the trcess utility and use tkprof utility to consolidate all the output files for a module.
 

Option C

C.    Use the trcess utility to consolidate all trace files into a single output file, which can then be processed by the tkprof utility.
 

Option D

D.    Use the tkprof utility to consolidate the trace files and create an output that can directly be used for diagnostic purposes.
 

Correct Answer C
Explanation

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