Oracle
1Z0-063 · Question #217
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…
The correct answer is B. All historical data older than two years, if any, is purged from the flashback archive FDA1. See the full explanation below for the reasoning.
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 fda1 MODIFY RETENSION 2 YEAR; What is the outcome?
Options
- AAn error is returned because the retention period cannot be reduced.
- BAll historical data older than two years, if any, is purged from the flashback archive FDA1.
- CAll the flashback data archives are purged and the subsequently created flashback archives are
- DAll historical data older than two years, if any, is archived to flashback logs and the flashback
How the community answered
(35 responses)- A3% (1)
- B74% (26)
- C9% (3)
- D14% (5)
Community Discussion
No community discussion yet for this question.