多項選擇題

Which are the prerequisites for performing flashback transactions on your database？（）

A. Undo retention guarantee for the database must be configured.
B. Supplemental log must be enabled for the primary key.
C. Supplemental log must be enabled.
D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

你可能感興趣的試題

多項選擇題

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.

單項選擇題

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.

Which are the prerequisites for performing flashback transactions on your database？（）

你可能感興趣的試題

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？（）

Which are the prerequisites for performing flashback transactions on your database？（）

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？（）