多項選擇題

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.

你可能感興趣的試題

單項選擇題

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

單項選擇題

You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

A. Whole database
B. Tablespaces
C. Datafiles
D. Archive logs
E. Redo logs

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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

You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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

You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）