Oracle
1Z0-117 · Question #70
1Z0-117 Question #70: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #70. The question stem and answer options stay visible for context.
Question
How can you analyze an existing trace file to list the almost resource-intensive statements, aggregation of statistics, and to either exclude recursive call details?
Options
- ABy using the DBMS_TRACE package
- BBy using the EXPLAIN PLAN command
- CBy enabling the SQL_TRACE parameter for the session
- DBy using the TKPROF utility
- EBy using the TRCSESS utility
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.