单项选择题

You experience a loss of the disk on which the USER_DAT……

You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45， which is needed to perform complete recovery， is invalid. You then begin incomplete recovery-You receive this prompt：
ORA-00279：change 309012...03/09/01 11：33：56 needed for thread ORA-00289： suggestion ：
/disk1/archive/arch_45.rdo ORA-00280： change 309012 for thread 1 is in sequence #45 Specify log：
{=suggested | filename | AUTO | CANCEL}
What is the correct response？（）

A.Enter the keyword AUTO.
B.Enter the keyword CANCEL.
C.Press the Enter or Return key.
D.Provide the filename ’/disk1/archive/arcg_46.rdo’

<上一题目录下一题>

热门试题

多项选择题WhichtwoRMANcommandsinitiatearesynchronizationoftherecoverycatalogwiththetargetdatabasecontrolfile？（）

A.COPY
B.BACKUP
C.CHANGE
D.DELETE
E.CATALOG

单项选择题You issue these LSNRCTL commands： LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02 What is the result of issuing these commands？（）

A.A listener named LISTENER is started.
B.A listener named LISTENER01 is started.
C.A listener named LISTENER02 is started.
D.The START command fails and no listener is started.

单项选择题ExaminetheRMANcommand：SWITCHDATAFILE’ DISK3 user_data01.dbf’；Whichcommanddoyouneedtoissuebeforeyouissuetheabovecommand，sothatRMANfindsthefileintherestoredlocationof’DISK2 user_data01.dbf’？（）

A.RESTORE DATAFILE ’/DISK2/user_data01.dbf’
B.RESTORE DATAFILE ’/DISK3/user_data01.dbf’
C.SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
D.SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’

单项选择题WhichstatementistrueregardingDynamicServiceRegistration？（）

A.Dynamic service registration requires configuration in the listener .ora file.
B.Dynamic service registration can be used only with an Oracle9/instance.
C.Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.
D.The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.

单项选择题You are implementing a very simple TCP IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests. Which naming method can you use？（）

A.Only host
B.Only local
C.Either host or local
D.Both host and local