OCP-1Z0-053-200题-117题-128

我是条汉子

　　QUESTION 117
　　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 are asked to change the retention period from 5 years to 3 years. To accomplish this, you
　　issued the following command:
　　ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS;
　　What is the outcome of this command?
　　A. The command produces an error because the retention period cannot be reduced
　　B. All historical data older than 3 years is purged from the flashback archive FLA1
　　C. All historical data is retained but the subsequentflashback data archives are maintained for only 3 years
　　D. All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new
　　retention time
　　Answer: B
　　同128题：http://blog.iyunv.com/rlhua/article/details/19208639
　　

　　Explanation/Reference:
　　Section: Flashback Operations & Configuration
         版权声明：本文为博主原创文章，未经博主允许不得转载。