READ Free Dumps For Oracle- 1z0-050
| Question ID 6079 | You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR; What is the implication of this command? |
| Option A | The command produces an error because the retention time cannot be reduced. |
| Option B | All historical data older than three years is purged from the flashback archive FLA1. |
| Option C | All historical data is purged and the new flashback data archives are maintained for three years. |
| Option D | All historical data is retained but the subsequent flashback data archives are maintained for only three years. |
| Correct Answer | B |
| Question ID 6080 | Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? |
| Option A | when ASM disk goes offline |
| Option B | when one or more ASM files are dropped |
| Option C | when some disks in a disk group are offline |
| Option D | when some disks in a failure group for a disk group are rebalancing |
| Correct Answer | C |