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 were asked to change the retention from 5 years to 3 years. To accomplish this， you issued the following command：   ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR；   What is the implication of this command？（）

A、 The command produces an error because the retention time cannot be reduced.

B、 All historical data is retained but the subsequent flashback data archives are maintained for only three years.

C、 All historical data is purged and the new flashback data archives are maintained for three years.

D、 All historical data older than three years is purged from the flashback archive FLA1.

相关问题推荐

• Evaluate the following function code：   CREATE FUNCTION get_dept_avg（dept_id NUMBER） RETURN NUMBER RESULT_CACHE RELIES_ON （EMPLOYEES） IS avgsal NUMBER（6）； BEGIN  SELECT AVG（SALARY）INTO avgsal FROM EMPLOYEES   WHERE DEPARTMENT_ID = dept_id； RETURN avgsal； END get_dept_avg；   Which statement is true regarding the above function？（）

  A、 The cached result becomes invalid when any structural change is done to the EMPLOYEES table. 

  B、 If the function execution results in an unhandled exception，the exception result is also stored in the cache.

  C、 Each time the function is invoked in a different session，the current result in the result cache gets overwritten.

  D、 If the function is invoked with a different parameter value，the existing result in the result cache gets overwritten by the latest value.

  查看答案

• Which dependent object will get invalidated even if it is not affected by the table edefinition？（）

  A、 packages

  B、 triggers

  C、 synonyms

  D、 views

  查看答案

• You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group？（）

  A

   The au_size disk group attribute determines the size of allocation units in the disk group. 

  B

   The allocation unit size may vary but the extent size is fixed.

  C

   The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

  D

   Extent management is completely automated.

  查看答案

• Which files are required for a full recovery of the database in ARCHIVELOG mode？（）

  A

   Database datafiles

  B

   Online redo logs

  C

   Archived redo logs

  D

   Backup control file

  E

   Control file from a backup

  查看答案

• Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

  A、 Automatic PGA Memory Management

  B、 Automatic SGA Memory Management

  C、 Automatic Shared Memory Management

  D、 Automatic Memory Management

  E、 Manual SGA Memory Management

  F、 None of the above

  查看答案