单项选择题
You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover?()
A. all the datafiles in the database
B. the datafiles associated with the SYSTEM tablespace
C. the datafiles associated with the DATA1 tablespace
D. all the datafiles in the database except those associated with the DATA1 tablespace
相关考题
-
单项选择题
YouareperforminganincompleterecoverybecausecertainimportanttablesweredeletedandpurgedfromtheRecycleBin.Inwhichmodewillyouperformtherecovery?()
A. MOUNT mode
B. RESTRICTED mode
C. OPEN mode
D. NOMOUNT mode -
单项选择题
InwhichsituationareyouNOTrequiredtoperformanincompleterecovery?()
A. when all the control files are lost
B. when all the members of a redo log group are lost
C. when a table is dropped and purged from the Recycle Bin
D. when a temporary file of the default temporary tablespace is lost -
单项选择题
Inwhichscenariowillyouperformacancel-basedrecovery?()
A. when a tablespace is dropped and you have only RMAN-based backup of the database
B. when a table is dropped and stored in the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when a tablespace is dropped and you have only a user-managed full backup of the database
