单项选择题
A. incomplete recovery
B. complete recovery
C. recovery using the Flashback Database feature
D. recovery using the export/import utility
单项选择题 You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement: SQL>ALTER DATABASE OPEN RESETLOGS; Which of the following options is true about using the RESETLOGS option?()
多项选择题 YouaremaintainingyourdatabaseinOracle10g.Youperformafulluser-managedbackupeverySundayat8:00P.M.YourdatabaseisrunninginARCHIVELOGmode.OnMonday,at9:00A.M.,atablespaceisdropped.Youdecidetoperformincompleterecoverytorecoverthedroppedtablespace.WhichtwoclausescanyouusewiththeRECOVERcommand?()
单项选择题 In which situation will you run the script containing the following statement?() CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG MAXLOGFILES 20 MAXLOGMEMBERS 3 MAXDATAFILES 30 MAXINSTANCES 10 MAXLOGHISTORY 1200 LOGFILE GROUP 1 ( ’/disk1/prod/orders/db/log1a.dbf’, ’/disk2/prod/orders/db/log1b.dbf’ )SIZE 100K GROUP 2 ( ’/disk1/prod/orders/db/log2a.dbf’, ’/disk2/prod/orders/db/log2b.dbf’ ) SIZE 100K, DATAFILE ’/disk1/prod/orders/db/database1.dbf’, ’/disk2/prod/orders/db/file1.dbf ’;