Oracle
1Z0-054 · Question #15
1Z0-054 Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Question
Examine the values for the following initialization parameters: STATISTICS_LEVEL = TYPICAL TIMED_STATISTICS = true You are managing an online transaction processing (OLTP) system. Application users notice that some queries have poor response time. You determine that queries from session ID 27, serial number 60, for user OE are heavy-resource consumers. To investigate further, you enabled tracing for the session by executing the following command: SQL> EXECUTE dbms_system.set_sql_trace_in_session (27, 60, true); Which statement is true?
Options
- AThe tkprof output file for the trace generated would display only the timed statistics for the SQL
- BThe tkprof output file for the trace generated would display statistics for all the sessions created
- CThe tkprof output file for the trace generated would display bind variable values if bind variables
- DThe tkprof output file for the trace generated would not display bind variable values if bind
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.