网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
当前oracle数据库运行在open状态，LISTENER也正常运行，此刻一个dba执行如下命令LSNRCTL>STOP下面的描述中那个是正确的？（）
- A、连接的会话不允许做任何操作直到监听启动
- B、会话断掉，并且当前的事物回滚
- C、当前连接的会话不受影响，操作继续
- D、会话只能执行查询操作
参考答案
更多 “当前oracle数据库运行在open状态，LISTENER也正常运行，此刻一个dba执行如下命令LSNRCTLSTOP下面的描述中那个是正确的？（）A、连接的会话不允许做任何操作直到监听启动B、会话断掉，并且当前的事物回滚C、当前连接的会话不受影响，操作继续D、会话只能执行查询操作” 相关考题
考题
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant
考题
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl >STOPWhat happens to the sessions that are presently connected to the database Instance?（）A. They are able to perform only queries.B. They are not affected and continue to function normally.C. They are terminated and the active transactions are rolled back.D. They are not allowed to perform any operations until the listener LISTENER is started
考题
当前oracle数据库运行在open状态,LISTENER也正常运行,此刻一个dba执行如下命令LSNRCTL>STOP下面的描述中哪个是正确的?()
A.连接的会话不允许做任何操作直到监听启动B.会话断掉，并且当前的事物回滚C.当前连接的会话不受影响，操作继续D.会话只能执行查询操作
考题
YouhavejustrunthissyntaxtostartthelistenerfromtheListenerControlutility：LSNRCTLSTARTStarting/mstgelai/oracle/bin/tnslsnr：pleasewait…Systemparameterfileis/u01/oracle/network/admin/listener.oraLogmessageswrittento/u01/oracle/network/log/listener.logListeningon：（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521）））Connectingto…ThecommandcompletedsuccessfullyWhatisthenameoftheListeneryoustarted？（）A.TNSLSNRB.LISTENERC.LOCAL_LISTENERD.DEFAULT_LSRN
考题
必须为用户帐户分配以下哪种权限，用户才能连接到Oracle数据库？（）A、ALTER SESSIONB、CREATE SESSIONC、OPEN SESSIOND、RESTRICTED SESSION
考题
You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）A、It gets it from the parameter file.B、The listener prompts for details on startup.C、The listener gathers information from the control file.D、The instance automatically registers with the default listener.E、The listener gets this information through thelistener.orafile.
考题
oracle数据库在nomount模式时，以下（）命令将数据库启动到mount模式。A、startupB、startup mountC、alter database mountD、alter database open
考题
Oracle数据库启动时需要经历三个步骤和状态变换，以下顺序正确的是（）。A、mount→open→nomountB、mount→open→closeC、close→open→mountD、nomount→mount→open
考题
当前数据库运行在open状态，LISTENER也正常运行，此刻一个dba执行如下命令LSNRCTLSTOP下面的描述中那个是正确的？（）A、会话只能执行查询操作B、连接的会话不允许做任何操作直到监听启动C、当前连接的会话不受影响，操作继续D、会话断掉，并且当前的事物回滚
考题
The listener uses dynamic information about the database and instance it has received through service registration before using information statically configured. Some services such as heterogeneous services and external procedures require the use of information statically configured within listener.ora. In order to support this， which tool could be used to configure the listener statically？（）A、Oracle Net ManagerB、Listener Control UtilityC、Oracle Net Control UtilityD、Oracle Net Configuration Assistant
考题
The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）A、 Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.B、 Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.C、 Issue the SERVICES command at the LSNRCTL prompt.D、 Issue the STATUS command at the LSNRCTL prompt.
考题
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A、 Oracle Net ManagerB、 Listener Control utilityC、 Database Configuration AssistantD、 Oracle Net Configuration Assistant
考题
多选题Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?（）AThread creation must be routed through a dispatcher processBThe local listener may spawn a now process and have that new process create a threadCEach Oracle process runs an SCMN thread.DEach multithreaded Oracle process has an SCMN thread.EThe local listener may pass the request to an existing process which in turn will create a thread.
考题
单选题You have just run this syntax to start the listener from the Listener Control utility： LSNRCTLSTART Starting /mstgelai/oracle/bin/tnslsnr： please wait… System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log Listening on： （DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521））） Connecting to… The command completed successfully What is the name of the Listener you started？（）A
TNSLSNRB
LISTENERC
LOCAL_LISTENERD
DEFAULT_LSRN
考题
单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A
Oracle Net ManagerB
Listener Control utilityC
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
单选题当前oracle数据库运行在open状态，LISTENER也正常运行，此刻一个dba执行如下命令LSNRCTLSTOP下面的描述中那个是正确的？（）A
连接的会话不允许做任何操作直到监听启动B
会话断掉，并且当前的事物回滚C
当前连接的会话不受影响，操作继续D
会话只能执行查询操作
考题
单选题当前数据库运行在open状态，LISTENER也正常运行，此刻一个dba执行如下命令LSNRCTLSTOP下面的描述中那个是正确的？（）A
会话只能执行查询操作B
连接的会话不允许做任何操作直到监听启动C
当前连接的会话不受影响，操作继续D
会话断掉，并且当前的事物回滚
考题
多选题You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）AIt gets it from the parameter file.BThe listener prompts for details on startup.CThe listener gathers information from the control file.DThe instance automatically registers with the default listener.EThe listener gets this information through thelistener.orafile.
考题
单选题The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）A
Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.B
Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.C
Issue the SERVICES command at the LSNRCTL prompt.D
Issue the STATUS command at the LSNRCTL prompt.
热门标签
最新试卷