READ Free Dumps For Oracle- 1z0-020
| Question ID 8195 | Which two statements are true? (Choose two) |
| Option A | Dimensions are based on summaries. |
| Option B | The ALTER MATERIALIZED VIEW CONSIDER FRESH statement directs Oracle to consider the materialized view fresh, and therefore eligible for query rewrite in the TRUSTED or STALE_TOLERATED mode only. |
| Option C | Summaries without dimensions are used for faster aggregation. |
| Option D | Additional query rewrites at a higher level of aggregation can take place if summaries are created at the lowest level of aggregation. |
| Correct Answer | A,D |
| Question ID 8196 | Which two statements are true? (Choose two) |
| Option A | Composite partitioning supports local indexes. |
| Option B | Composite partitioning supports hash-partitioned global indexes. |
| Option C | Composite partitioning supports range-partitioned global indexes |
| Option D | Composite partitioning supports composite-partitioned global indexes. |
| Correct Answer | B,D |