单项选择题
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）
A. STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
B. STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
C. STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
D. STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
相关考题
-
单项选择题
Youareperformingadatabaserecoverybecauseauser’sschemaisdropped.Whileperformingtherecovery，youusetheUNTILSEQUENCEclause.Whichtypeofdatabaserecoveryareyouperforming？（）
A. user managed complete recovery
B. user managed incomplete recovery
C. RMAN-based complete recovery
D. RMAN-based incomplete recovery -
单项选择题
You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMAN>RUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }
A. NOMOUNT
B. MOUNT
C. OPEN
D. RESTRICTED -
单项选择题
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL> DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）
A. the datafiles associated with the SYSTEM tablespace
B. the datafiles associated to the DATA1 tablespace
C. the datafiles associated to the SYSTEM and DATA1 tablespaces
D. all the datafiles in the database
