Oracle
1Z0-117 · Question #115
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: Which two statements are…
The correct answer is C. SQL statements in the output files are stored in the order of elapsed time. D. TKPROF use TEMP_PLAN_TABLE in the HR schema as a temporary plan table. See the full explanation below for the reasoning.
Question
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:
Which two statements are correct about the execution of the command?
Options
- ASCRIPT.SQL stores the statistics for all traced SWL statements.
- BExecution plans for SQL statements are stored in TEMP_PLAN_TABLE and can be queried by the user.
- CSQL statements in the output files are stored in the order of elapsed time.
- DTKPROF use TEMP_PLAN_TABLE in the HR schema as a temporary plan table.
- ERecursive SQL statements are included in the output file.
How the community answered
(31 responses)- A3% (1)
- B6% (2)
- C81% (25)
- E10% (3)
Community Discussion
No community discussion yet for this question.