单项选择题
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）
A. use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B. restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform point-in-time recovery to recover the table
相关考题
-
单项选择题
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）
A. 2， 7， 3， 5， 1， 6， 4
B. 2， 1， 7， 6， 3， 5， 4
C. 7， 1， 3， 2， 6， 5， 4
D. 7， 2， 3， 1， 4， 6， 5 -
单项选择题
Youareworkingonadatabase，whereyouhavethreeredologgroups.Whenthedatabaseisdownforabackup，anoperatingsystem（OS）userdeletesalltheredologfilesinagroup.Whatwillhappenwhenyouopenyourdatabase？（）
A. The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
B. Before the instance starts， you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens because two redo log groups still exist.
E. The instance starts and the database opens， but every attempt to write to redo log files fails with an error. -
单项选择题
Youhaveonlytworedologgroupsandthesegroupsgetoverwrittenseveraltimesinaday.Your databaseoperatesinNOARCHIVELOGmodeanduser-managedconsistentbackupsareperformedeverySundaynight.OnThursdaymorning，youfindthatanimportanttablehasbeendroppedandpurged.Withreferencetothisscenario，uptowhatpointintimecanthedataberecovered？（）
A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday’s backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening
