The EXPLAIN PLAN command, the Autotrace feature in SQL*Plus, and the TKPROF utility each have the following in common?
A . Each requires the explain_table in the schema of the SQL originator.
B . The PLAN_TABLE must exist for each in all conditions.
C. A plan table is required for each, and for TKPROF when explain=username/password.
D . Each requires the DBA or Unix administrator to execute.
E . They each run within a SQL*Plus session.
Explanation:
Answer C: Both the EXPLAIN PLAN command and the Autotrace option require a plan table. The TKPROF command requires the plan table only if the explain parameter is included.
No comments:
Post a Comment