READ Free Dumps For Oracle- 1z0-146
| Question ID 2863 | Which three statements are true about hierarchical profiling? (Choose three.) |
| Option A | A. It provides function-level summaries. |
| Option B | B. It produces an aggregated report of the SQL and PL/SQL execution times. |
| Option C | C. It is useful for understanding the structure and control flow of complex programs. |
| Option D | D. It can be used to identify hotspots and tuning opportunities in PL/SQL applications. |
| Option E | E. It generates trace information for PL/SQL programs in the PLSQL_TRACE_EVENTS table. |
| Correct Answer | A,C,D |
| Question ID 2864 | Which two statements are true about cursor variables? (Choose two.) |
| Option A | A. Cursor variables can be parameterized like cursors. |
| Option B | B. The query associated with a cursor variable cannot reference host variables and PL/SQL variables. |
| Option C | C. The FETCH statement executes the query associated with a cursor variable and identifies the result set. |
| Option D | D. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable. |
| Option E | E. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set. |
| Correct Answer | D,E |