READ Free Dumps For Oracle- 1z0-050
| Question ID 1861 | Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.) |
| Option A | A. Diagnose and repair a data file corruption offline. |
| Option B | B. Diagnose and repair a data file corruption online. |
| Option C | C. Diagnose and repair failures on a standby database. |
| Option D | D. Recover from failures in the Real Application Cluster (RAC) environment. |
| Correct Answer | C,D |
| Question ID 1862 | In which cases is reference partitioning effective in enhancing performance? |
| Option A | A. It is effective only in partition pruning. |
| Option B | B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key. |
| Option C | C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key. |
| Option D | D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key. |
| Correct Answer | D |