单项选择题
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.
What must you do accomplish this task?（）
A. Enable supplemental logging for the database.
B. Specify undo retention guarantee for the database
C. Create Flashback Data Archive in the tablespace where the tables are stored.
D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables
相关考题
-
单项选择题
Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified？（）
A. only the control file， the current SPFILE， and data files
B. only the current SPFILE and data files if autobackup is disabled
C. only the data files and the archived redo logs
D. the control file，current SPFILE file，data files，and archived redo logs -
多项选择题
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). -
多项选择题
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.（） (Choose two.)
A. The data file backup is done with multiple channels
B. The data files is in the read-write mode after being backed up in the read only mode
C. The backup was taken after the data files was taken offline-normal or is in the read only mode
D. The data file backup complies with the back retention policy and the backup duplexing feature
