多项选择题
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 -
单项选择题
YouareusingRecoverywizardforperformingincompleterecovery.WhichofthefollowingobjecttypesisNOTavailableinthePerformRecovery：Typescreen？（）
A. Whole database
B. Tablespaces
C. Datafiles
D. Archive logs
E. Redo logs -
单项选择题
InwhichscenarioisaDatabaseAdministratorNOTrequiredtoperformanincompleterecovery？（）
A. when all the online redo log groups are multiplexed and one of the members of a group is missing
B. when all the online redo log groups are not multiplexed and one log group is missing
C. when all the control files are missing
D. when some important tables are deleted from the database and purged from the Recycle Bin
