相关考题

单项选择题 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 ’;