單項(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

你可能感興趣的試題

多項(xiàng)選擇題

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

A. The DBWn process writes to the datafile.
B. Changes in the background process are recorded.
C. The log file is updated with the current SCN number.
D. The System Change Number （SCN） is recorded in the control file.
E. The changes to the listener configuration in the listener.ora file are recorded.

單項(xiàng)選擇題

You are maintaining the SALES database of TeleStar Corporation. The online redo log configuration of the database is as follows：

One of the redo log members， redo3b， is lost due to disk failure. How will you recover the redo log member redo3b？（）

A. by performing an incomplete recovery from the last backup
B. by performing an import operation
C. by performing a complete database recovery
D. by dropping the lost member and adding a new redo log member

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

你可能感興趣的試題

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

You are maintaining the SALES database of TeleStar Corporation. The online redo log configuration of the database is as follows： One of the redo log members， redo3b， is lost due to disk failure. How will you recover the redo log member redo3b？（）

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

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

You are maintaining the SALES database of TeleStar Corporation. The online redo log configuration of the database is as follows：

One of the redo log members， redo3b， is lost due to disk failure. How will you recover the redo log member redo3b？（）