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. |
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 |
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: |
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 |