Tracing has been enabled for the HR user. You execute the following command to check the
contents of the orcl_25052.trc trace file, which was generated during tracing: 
Which two statements are correct about the execution of the command?
A.
SCRIPT.SQL stores the statistics for all traced SWL statements.
B.
Execution plans for SQL statements are stored in TEMP_PLAN_TABLE and can be queried by
the user.
C.
SQL statements in the output files are stored in the order of elapsed time.
D.
TKPROF use TEMP_PLAN_TABLE in the HR schema as a temporary plan table.
E.
Recursive SQL statements are included in the output file.
Explanation:
For me answer are A,D
A:
INSERT
Creates a SQL script that stores the trace file statistics in the database. TKPROF creates this script with the name filename3. This script creates a table and inserts a row of statistics for each traced SQL statement into the table.
D:
TABLE
Specifies the schema and name of the table into which TKPROF temporarily places execution plans before writing them to the output file. If the specified table already exists, then TKPROF deletes all rows in the table, uses it for the EXPLAIN PLAN statement (which writes more rows into the table), and then deletes those rows. If this table does not exist, then TKPROF creates it, uses it, and then drops it.
The specified user must be able to issue INSERT, SELECT, and DELETE statements against the table. If the table does not already exist, then the user must also be able to issue CREATE TABLE and DROP TABLE statements. For the privileges to issue these statements, see the Oracle9i SQL Reference.
This option allows multiple individuals to run TKPROF concurrently with the same user in the EXPLAIN value. These individuals can specify different TABLE values and avoid destructively interfering with each other’s processing on the temporary plan table.
If you use the EXPLAIN parameter without the TABLE parameter, then TKPROF uses the table PROF$PLAN_TABLE in the schema of the user specified by the EXPLAIN parameter. If you use the TABLE parameter without the EXPLAIN parameter, then TKPROF ignores the TABLE parameter.
If no plan table exists, TKPROF creates the table PROF$PLAN_TABLE and then drops it at the end.
Agree, A and D.
No E since SYS=NO
No C since the order of elapsed time is EXEELA or FCHELA.
No B since TKPROF deletes rows from temporary table, so they cannot be queried