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