日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

單項(xiàng)選擇題

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？（）

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.

題目列表

你可能感興趣的試題

單項(xiàng)選擇題

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

A. when all the control files are missing and only a binary backup of the current control file exists
B. when a multiplexed copy of the current control file is missing
C. when all the control files are missing and only an ASCII representation of the binary control file exists
D. when the SPFILE is missing
微信掃碼免費(fèi)搜題