READ Free Dumps For Oracle- 1z0-117
| Question ID 2524 | Tracing has been enabled for the HR user. You execute the following command to check the contents of the orcl_25052.trc trace file, which was generated during tracing: |
| Option A | A. SCRIPT.SQL stores the statistics for all traced SWL statements. |
| Option B | B. Execution plans for SQL statements are stored in TEMP_PLAN_TABLE and can be queried by the user. |
| Option C | C. SQL statements in the output files are stored in the order of elapsed time. |
| Option D | D. TKPROF use TEMP_PLAN_TABLE in the HR schema as a temporary plan table. |
| Option E | E. Recursive SQL statements are included in the output file. |
| Correct Answer | A,D |
| Question ID 2525 | You are administering a database that supports an OLTP application. To set statistics preferences, you issued the following command: |
| Option A | A. It will influence the gathering of statistics for a table based on the value specified for ESTIMATE_PERCENT provided on table preferences for the same table exist. |
| Option B | B. It will influence dynamic sampling for a query to estimate the statistics based on ESTIMATE_PERCENT. |
| Option C | C. The automatic statistics gathering job running in the maintenance window will use global preferences unless table preferences for the same table exist. |
| Option D | D. New objects created will use global preference even if table preferences are specified. |
| Correct Answer | D |