READ Free Dumps For Oracle- 1z0-117
| Question ID 2605 | How can you analyze an existing trace file to list the almost resource-intensive statements, aggregation of statistics, and to either exclude recursive call details? |
| Option A | A. By using the DBMS_TRACE package |
| Option B | B. By using the EXPLAIN PLAN command |
| Option C | C. By enabling the SQL_TRACE parameter for the session |
| Option D | D. By using the TKPROF utility |
| Option E | E. By using the TRCSESS utility |
| Correct Answer | D |
| Question ID 2606 | Which statement is true about the usage of the STAR_TRANSFORMATION hint in a query? |
| Option A | A. The optimizer always uses a plan in which the transformation is used. |
| Option B | B. The optimizer uses transformation only if the cost is less than a query executing without transformation. |
| Option C | C. The optimizer always generates subqueries to transform a query. |
| Option D | D. The optimizer always uses bitmap indexes on the primary key column for any dimension table to transform a query. |
| Correct Answer | B |