READ Free Dumps For Oracle- 1z0-050
| Question ID 5985 | Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements? |
| Option A | Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans. |
| Option B | Capture the plans from the previous version using STS and then load them into the stored outline. |
| Option C | Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB). |
| Option D | Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline. |
| Correct Answer | C |
| Question ID 5986 | You are managing Oracle Database 11 g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours: ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H; Which statement is true in this scenario? |
| Option A | It starts the ASM fast mirror resync. |
| Option B | It drops all disk paths from the dga disk group. |
| Option C | All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours. |
| Option D | All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours. |
| Correct Answer | D |