你可能感興趣的試題

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

單項(xiàng)選擇題

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

A. incomplete recovery
B. complete recovery
C. recovery using the Flashback Database feature
D. recovery using the export/import utility

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； }

你可能感興趣的試題

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

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；
}

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）