READ Free Dumps For Oracle- 1z0-117
Question ID 2504 | Examine Exhibit1 to view the query and its AUTOTRACE output. |
Option A | A. The displayed plan will be stored in PLAN_TABLE. |
Option B | B. Subsequent execution of this statement will use the displayed plan that is stored in v$SQL. |
Option C | C. The displayed plan may not necessarily be used by the optimizer. |
Option D | D. The query will not fetch any rows; it will display only the execution plan and statistics. |
Option E | E. The execution plan generated can be viewed from v$SQLAREA. |
Correct Answer | A,D |
Question ID 2505 | Which two types of column filtering may benefit from partition pruning? |
Option A | A. Equally operates on range-partitioned tables. |
Option B | B. In-list operators on system-partitioned tables |
Option C | C. Equality operators on system-partitioned tables |
Option D | D. Operators on range-partitioned tables |
Option E | E. Greater than operators on hash-partitioned tables |
Correct Answer | A,D |