Which two statements are true?

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.)

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.)

A.
It generates only a report on the execution path used by the SQL optimizer.

B.
Trace for the statement would be created without displaying the query output.

C.
It generates only the statement execution statistics without executing the query.

D.
It generates a report on the execution path used by the SQL optimizer and the statement
execution statistics.

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Rodrigo

Rodrigo

Tracing Statements

You can automatically get a report on the execution path used by the SQL optimizer and the statement execution statistics.

…

SET AUTOTRACE TRACEONLY

Like SET AUTOTRACE ON, but suppresses the printing of the user’s query output, if any. If STATISTICS is enabled, query data is still fetched, but not printed.

Reply

Rodrigo

Rodrigo

B and D are correct.

Reply