kinila 发表于 2015-11-9 10:25:26

OCP-1Z0-053-200题-43题-678

  QUESTION 43
  Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)
  A. Flash recovery area must be defined
  B. Undo retention guarantee must be enabled.
  C. Database must be running in archivelog mode.
  D. Automatic undo management must be enabled.
  E. The tablespace in which the Flashback Data Archive is created must have automatic segment space
  Management (ASSM).
  Answer: DE
  同678题:http://blog.iyunv.com/rlhua/article/details/14138063
  

  Explanation/Reference:
  Section: Flashback Operations & Configuration
  http://www.oracle.com/technetwork/database/features/storage/total-recall-whitepaper-171749.pdf?
  ssSourceSiteId=ocomen
  Oracle White Paper- Oracle Total Recall withOracle Database 11g Release 2, Page 7
  Flashback Data Archive Requirements
  1. Flashback Data Archive tablespaces must be managed with automatic segment space management (ASSM).
  2. Automatic Undo Management must be enabled.
  http://www.dba-oracle.com/t_11g_new_enabling_fdba.htm
  There are a number of restrictions for flashback archives:
  - The tablespaces used for a flashback archive must use local extent managementand automatic segment space management.
  - The database must use automatic undo management.
         版权声明:本文为博主原创文章,未经博主允许不得转载。
页: [1]
查看完整版本: OCP-1Z0-053-200题-43题-678