单项选择题
You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery, you issued the following statement:
SQL>ALTER DATABASE OPEN RESETLOGS;
What will be the resultant log sequence numbers?()
A. 0 and 1
B. 1 and 2
C. 1005 and 1006
D. 1006 and 1007
相关考题
-
单项选择题
Inwhichscenariowillyouperformauser-managedincompleterecovery?()
A. when a table is dropped and stored in the Recycle Bin
B.when a table is dropped and purged from the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when you are required to view all the versions of a row of an existing table between a specific time period -
单项选择题
YoutooktheDATA1tablespaceofflineat10:00A.M.At12:30P.M.,aschemaofauserisdroppedandpurgedfromtheRecycleBin.Younoticedthisat2:00P.M.anddecidedtoperformanincompleterecovery.Whichdatafileswillyourecover?()
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
