READ Free Dumps For Oracle- 1z0-020
| Question ID 7788 | Which statement is true regarding composite partitions? |
| Option A | Partitions and subpartitions can use either hash or the range method. |
| Option B | Partitions use the range method and subpartitions use the hash method. |
| Option C | Partitions use the hash method and subpartitions the range method. |
| Option D | Partitions use either the hash or range method, and subpartitions can use only the hash methods. |
| Option E | Partitions and subpartitions can use either the hash or range method, if both use the same method. |
| Correct Answer | B |
| Question ID 7789 | What must you do to enable partition-wise joins? |
| Option A | Nothing, because this feature is enabled automatically. |
| Option B | The instance parameter partition_wise_joins must be set to "TRUE" |
| Option C | The table parameter partition_wise_joins must be set using an "ALTER TABLE. . . ." statement. |
| Option D | The parameter partition_wise_join must be set when the table is created. |
| Option E | In the select statement, use the hint/*partition_wise_joins*/ |
| Correct Answer | A |