READ Free Dumps For Oracle- 1z0-117
| Question ID 2617 | Which three options are true about MVIEWs? |
| Option A | A. The defining query of an MVIEWs may be based on a populated table. |
| Option B | B. Queries that are rewritten to an MVIEW will never obtain results from the result cache. |
| Option C | C. All MVIEWS may be configured to support “refresh on demand”. |
| Option D | D. The defining query of an MVIEW may be based on non_partitioned table. |
| Option E | E. All MVIEWs may be configured to support “refresh on commit” |
| Correct Answer | A,B,C |
| Question ID 2618 | Partial details of an execution plan. |
| Option A | A. It produces a bitmap, representing dimension table rows from all dimension tables that join with qualified fact table rows. |
| Option B | B. It produces a concentration of the bitmaps for all dimension tables. |
| Option C | C. It produces a bitmap, representing fact table rows that do not join with qualified dimension table rows from all dimension tables. |
| Option D | D. It produces a bitmap, representing fact table rows that join with qualified dimension table rows from all dimension tables. |
| Correct Answer | D |
