Oracle
1Z0-054 · Question #11
You identified a SQL statement with SQL ID 9g485acn2n30m, which is expensive on the resources. To view the execution plan for the statement, you executed the following command: SQL> SELECT * FROM…
The correct answer is A. It formats and displays the contents of the execution plan for the cursor with the SQL_ID. See the full explanation below for the reasoning.
Question
You identified a SQL statement with SQL ID 9g485acn2n30m, which is expensive on the resources. To view the execution plan for the statement, you executed the following command:
SQL> SELECT * FROM TABLE(dbms_xplan.display_cursor('9g485acn2n30m',1)); What would this command accomplish?
Options
- AIt formats and displays the contents of the execution plan for the cursor with the SQL_ID
- BIt formats and displays the contents of the execution plan but does not guarantee accuracy if the
- CIt formats and displays the contents of the execution plan but does not guarantee that the same
- DIt formats and displays the contents of the execution plan for the cursor with the SQL_ID
How the community answered
(25 responses)- A80% (20)
- B12% (3)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.