我是条汉子 发表于 2015-11-9 10:39:51

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
         版权声明:本文为博主原创文章,未经博主允许不得转载。
页: [1]
查看完整版本: OCP-1Z0-053-200题-117题-128