You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

You have recovered your Oracle Database 10g by using th...

单项选择题

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.Youperformaful...

多项选择题You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

In which situation will you run the script containing t...

单项选择题

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 ’；