Oracle
1Z0-054 · Question #14
You enabled tracing for a session by executing the following command: SQL>SET AUTOTRACE TRACEONLY; You issued a SQL query in the same session. Which two statements are true? (Choose two.)
The correct answer is B. Trace for the statement would be created without displaying the query output. D. It generates a report on the execution path used by the SQL optimizer and the statement. See the full explanation below for the reasoning.
Question
You enabled tracing for a session by executing the following command:
SQL>SET AUTOTRACE TRACEONLY; You issued a SQL query in the same session. Which two statements are true? (Choose two.)
Options
- AIt generates only a report on the execution path used by the SQL optimizer.
- BTrace for the statement would be created without displaying the query output.
- CIt generates only the statement execution statistics without executing the query.
- DIt generates a report on the execution path used by the SQL optimizer and the statement
How the community answered
(23 responses)- A4% (1)
- B83% (19)
- C13% (3)
Community Discussion
No community discussion yet for this question.