Oracle
1Z0-064 · Question #37
1Z0-064 Question #37: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #37. The question stem and answer options stay visible for context.
Question
Examine this list of possible tasks: 1. Ensure that STATISTICS_LEVEL is set to TYPICAL or ALL. 2. Ensure that TIMED_STATISTICS is set to TRUE. 3. Set MAX_DUMP_FILE_SIZE to UNLIMITED and DIAGNOSTIC_DEST to an appropriate destination. 4. Ensure that SQL_TRACE is set to TRUE. 5. Enable tracing at the database instance level by using the DBMS_MONITOR.DATABASE_TRACE_ENABLE procedure. 6. Enable tracing in the required session by using the DBMS_SESSION.SET_SQL_TRACE procedure. 7. Run TKPROF with the EXPLAIN parameter on the output trace file. 8. Run the trcsess utility on the output trace files, and then run TKPROF on the output of the trcsess utility. Select the minimum tasks to perform, in the correct order, to generate both a formatted trace file with timing information and an explain plan for each SQL statement for all sessions. (Choose the best answer.)
Options
- A1, 2, 5, 8
- B1, 3, 6, 7
- C2, 4, 5, 8
- D1, 3, 4, 5, 6, 7
- E1, 2, 4, 8
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.