READ Free Dumps For Oracle- 1z0-020
| Question ID 7802 | Which two statements are true regarding partitioned tables/ (Choose two) |
| Option A | Partitions must reside in the same tablespace. |
| Option B | Partitions must be the same size. |
| Option C | Partitions may only reside in read/write tablespaces. |
| Option D | Partitions may only reside in read only tablespaces. |
| Option E | Row movement between partitions is allowed only if row movement is enabled. |
| Option F | Row movement between partitions is allowed default. |
| Correct Answer | BE |
| Question ID 7803 | Which two statements are true for materialized view? (Choose two) |
| Option A | They must be rebuilt manually. |
| Option B | They cannot have indexes built on columns. |
| Option C | They can reduce the table joins required for a query. |
| Option D | They must be built in the same tablespace as the base tables. |
| Option E | They can have different storage parameters than the base tables. |
| Correct Answer | BE |