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.



Leave a Reply 0

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