READ Free Dumps For Oracle- 1z0-050
Question ID 1949 | |
Option A | A. The DISK_ASYNCH_IO parameter is set to TRUE. |
Option B | B. The FILESYSTEMIOJDPTIONS parameter is set to NONE. |
Option C | C. Another session runs the I/O calibration process concurrently. |
Option D | D. The pending area has not been created before running the I/O calibration process. |
Correct Answer | B |
Question ID 1950 | 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; |
Option A | A. The command produces an error because the retention time cannot be reduced. |
Option B | B. All historical data older than three years is purged from the flashback archive FLA1. |
Option C | C. All historical data is purged and the new flashback data archives are maintained for three years. |
Option D | D. All historical data is retained but the subsequent flashback data archives are maintained for only three years. |
Correct Answer | B |