单项选择题

You want to configure the Flashback Database feature an……

You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this：
1. Set the retention target：
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320；
2. Enable Flashback Database：
SQL> ALTER DATABASE FLASHBACK ON；
3. Mount the database：
SQL> STARTUP MOUNT EXCLUSIVE
4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE
5. Open the database：
SQL> ALTER DATABASE OPEN；
Choose the correct sequence.（）

A. 4， 1， 3， 2， 5
B. 4， 3， 1， 2， 5
C. 2， 4， 3， 5， 1
D. 4， 2， 5， 3， 1

<上一题目录下一题>

热门试题

多项选择题Whichtwocommandsnevertriggeranimplicitrebalancingwithinthediskgroup？（）

A. ALTER DISKGROUP misc MOUNT
B. ALTER DISKGROUP misc DROP DISK misc2
C. ALTER DISKGROUP misc CHECK ALL NOREPAIR
D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m
E. ALTER DISKGROUP dgroupA ADD DISK ’/devices/A*’

多项选择题IndentifytwoadvantagesofusingrecoverycataloginsteadofthecontrolfileofthedatabaseinRecoveryManager（RMAN）.（）

A. You can use RMAN stored scripts
B. Recovery is faster if data is stored in catalog in addition to the control file
C. You can store backup information of all registered databases in one place
D. Database backups are automatically deleted when they are older than the specified time period

单项选择题The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner？（）

A. Allow the database to continue running，drop the TEMP tablespace，and then re-create it with new tempfiles
B. Shut down the database， restore and recover the tempfile from backup，and then open the database with RESETLOGS
C. Allow the database to continue running，take the TEMP tablespace offline，drop the missing tempfile，and then create a new tempfile
D. Allow the database to continue running，add a new tempfile to TEMP tablespace with a new name，and drop the tempfile that has been corrupted

单项选择题TheBACKUP_TAPE_IO_SLAVESparameterissettoFALSEforthedatabaseinstance.WhichstatementistruewhileperformingatapebackupinanRMANsession？（）

A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area （SGA）
C. The tape buffer is allocated from the Program Global Area （PGA）
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

单项选择题Examine the following ALTER command： SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS； What is the purpose of the command？（）

A. It cancels all pending disk drops within the disk group.
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group