Oracle
1Z0-034 · Question #49
1Z0-034 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
Question
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?
Options
- AThe command produces an error because the retention time cannot be reduced.
- BAll historical data is retained but the subsequent flashback data archives are maintained for only
- CAll historical data is purged and the new flashback data archives are maintained for three years.
- DAll historical data older than three years is purged from the flashback archive FLA1.
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.