Oracle
1Z0-117 · Question #115
1Z0-117 Question #115: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #115. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.