单项选择题
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 -
单项选择题
YouaremaintainingyourdatabaseinOracle10g.OnTuesdayat8:00A.M.,whilestartingthedatabase,youdiscoverthatallthecontrolfilesaremissing.ThebackupofthefulldatabasewasperformedonSundayat6:00P.M.Whichtypeofrecoverywillyouperform?()
A. incomplete recovery
B. complete recovery
C. recovery using the Flashback Database feature
D. recovery using the export/import utility
