READ Free Dumps For Oracle- 1z0-020
| Question ID 8217 | Which two statements are true for materialized views? (Choose two) |
| Option A | They must be built in the SYSTEM tablespace. |
| Option B | They can reduce the aggregation required for a query. |
| Option C | They are rebuilt with the ALTER VIEW . . . REBUILD command. |
| Option D | They can be created in a different tablespace than the base tables. |
| Option E | A container table stores the data for multiple materialized view objects. |
| Correct Answer | B,D |
| Question ID 8218 | Which statement is true? |
| Option A | Materialized view based on prebuilt tables are eligible for selection by query rewrite, provided that the QUERY_REWRITE_INTEGRITY parameter is set to TRUSTED or STALE_TOLERATED. |
| Option B | Query rewrites occur only if dimensions are present. |
| Option C | Materialized views are eligible for fast refresh even if the defining query contains an analytic function in 8.1.6 |
| Option D | Query rewrites occur only if summaries are created at the lowest level of aggregation. |
| Correct Answer | A |