单项选择题
A. The log sequence is reset to 0.
B. All the online redo logs are deleted.
C. All the archived redo logs from a previous incarnation become useless.
D. The full database backup taken from a previous incarnation can be used in future.
E. Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
多项选择题 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 ’；
多项选择题 You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance： SQL> ALTER SYSTEM SWITCH LOGFILE； Which two tasks are performed when the statement is executed？ （）