单项选择题

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；

点击查看答案

上一题目录下一题

相关考题

单项选择题

You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

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