Oracle
1Z0-083 · Question #177
1Z0-083 Question #177: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #177. The question stem and answer options stay visible for context.
Backup and Recovery
Question
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?
Options
- AAll historical data older than two years, if any, is purged from the flashback archive FDA1.
- BAn error is returned because the retention period cannot be reduced.
- CAll the flashback data archives are purged and the subsequently created flashback archives
- DAll historical data older than two years, if any, is archived to flashback logs and the flashback
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 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.
Topics
#Flashback Data Archive#Retention policies#Historical data management#Data purging