READ Free Dumps For Oracle- 1z0-117
| Question ID 2576 | Which four types of column filtering may benefit from partition pruning when accessing tables via partitioned indexes? |
| Option A | A. Equality operates on List-Partitioned Indexes |
| Option B | B. Not Equal operates on a Global Hash-Partitioned Indexes |
| Option C | C. Equality operates on System-Partitioned Tables |
| Option D | D. In-List operates on Range-Partitioned Indexes |
| Option E |
|
| Option F | F. Equality operates on Range-Partitioned Indexes |
| Correct Answer | A,D,E,F |
| Question ID 2577 | You executed the following statement: |
| Option A | A. The execution plan is saved in PLAN_TABLE without executing the query. |
| Option B | B. The execution plan for the query is generated and displayed immediately as the output. |
| Option C | C. The execution plan generated may not necessarily be the execution plan used during query execution. |
| Option D | D. The execution plan is saved in DBA_HIST_SQL_PLAN without executing the query. |
| Option E | E. The execution plan generated can be viewed using the DBMS_XPLAIN.DISPLAY function. |
| Option F | F. The execution plan generated can be fetched from the library cache by using the DBMS XPLAIN.DISPLAY function. |
| Correct Answer | A,C,E |
