单项选择题
You are maintaining your database in ARCHIVELOG mode. An important table, SCOTT.EMPLOYEE, is dropped and purged from the Recycle Bin on Monday at 2:00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9:00 P.M. on Sunday. How will you recover the dropped table, SCOTT.EMPLOYEE?()
A. by using the Flashback Table feature
B. by using the Flashback Database feature
C. by performing incomplete recovery using RMAN utility
D. by performing incomplete recovery using user-managed recovery
相关考题
-
单项选择题
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
