网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
当前oracle数据库运行在open状态,LISTENER也正常运行,此刻一个dba执行如下命令LSNRCTL>STOP下面的描述中那个是正确的?()
A

连接的会话不允许做任何操作直到监听启动

B

会话断掉,并且当前的事物回滚

C

当前连接的会话不受影响,操作继续

D

会话只能执行查询操作


参考答案

参考解析
解析: 暂无解析
更多 “单选题当前oracle数据库运行在open状态,LISTENER也正常运行,此刻一个dba执行如下命令LSNRCTLSTOP下面的描述中那个是正确的?()A 连接的会话不允许做任何操作直到监听启动B 会话断掉,并且当前的事物回滚C 当前连接的会话不受影响,操作继续D 会话只能执行查询操作” 相关考题
考题 Linux系统中,启动监听服务的命令是:A.listener startB.listener startupC.lsnrctl startD.lsnrctl startup

考题 Linux系统中,查看监听服务状态的命令是:A.listener stateB.listener statusC.lsnrctl stateD.lsnrctl status.

考题 以数据库超级管理员的身份连接到一个用户名system、密码oracle、名称为lteomc的数据库的命令为________。A.sqlplus system/oracle@lteomc as sysdbaB.sqlplus sys/oracle@lteomc as dbaC.sqlplus system:oracle@lteomc as sysdbaD.sqlplus sys:oracle@lteomc as dba

考题 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.会话只能执行查询操作

考题 如何设置listener口令?()A、以Oracle用户运行lsnrctl命令B、setlog_fileC、change_passwordD、setpasswordE、save_config

考题 当前数据库运行在open状态,LISTENER也正常运行,此刻一个dba执行如下命令LSNRCTL>STOP下面的描述中那个是正确的?() A.会话只能执行查询操作B.连接的会话不允许做任何操作直到监听启动C.当前连接的会话不受影响,操作继续D.会话断掉,并且当前的事物回滚

考题 You executed the following command in the lsnrctl utility to stop the listener: lsnrctl STOP L1  What is the effect of this command if L1 is the only listener configured for your database?()A、It terminates all user sessions.B、It prevents users from logging in to the database remotely.C、It halts the server until all user transactions are completed.D、The server hangs, so users will receive an error asking them to login again.E、Connected users would get an error with the message "End of communication channel".

考题 DBA可以使用下列()命令查看当前数据库归档状态。A、ARCHIVE LOGLISTB、FROMARCHIVE LOGSC、SELECT*FROMV$THREADD、SELECT*FROMARCHIVE_LOG_LIST

考题 当前数据库运行在open状态,LISTENER也正常运行,此刻一个dba执行如下命令LSNRCTLSTOP下面的描述中那个是正确的?()A、会话只能执行查询操作B、连接的会话不允许做任何操作直到监听启动C、当前连接的会话不受影响,操作继续D、会话断掉,并且当前的事物回滚

考题 当前oracle数据库运行在open状态,LISTENER也正常运行,此刻一个dba执行如下命令LSNRCTLSTOP下面的描述中那个是正确的?()A、连接的会话不允许做任何操作直到监听启动B、会话断掉,并且当前的事物回滚C、当前连接的会话不受影响,操作继续D、会话只能执行查询操作

考题 Linux系统中,停止监听服务的命令是:A、listener stopB、listener endC、lsnrctl stopD、lsnrctl end

考题 Linux系统中,查看监听服务状态的命令是()A、listener stateB、listener statusC、lsnrctl stateD、lsnrctl status

考题 以数据库超级管理员的身份连接到一个用户名system、密码oracle、名称为lteomc的数据库的命令为()A、sqlplus system/oracle@lteomc as sysdbaB、sqlplus sys/oracle@lteomc as dbaC、sqlplus system:oracle@lteomc as sysdbaD、sqlplus sys:oracle@lteomc as dba

考题 Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command:LSNRCTL STOP What happens to the sessions that are presently connected to the database instance()A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The sessions are terminated and the active transactions are rolled back.D、The sessions are not allowed to perform any operations till the listener is started

考题 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 is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command:  LSNRCTL STOP  What happens to the sessions that are presently connected to the database instance()A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The sessions are terminated and the active transactions are rolled back.D、The sessions are not allowed to perform any operations till the listener is started.

考题 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.

考题 多选题如何设置listener口令?()A以Oracle用户运行lsnrctl命令Bsetlog_fileCchange_passwordDsetpasswordEsave_config

考题 单选题Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command: LSNRCTL STOP  What would happen to the sessions that are presently connected to the database instance?()A The sessions are able to perform only queries.B The sessions are not affected and continue to function normally.C The active transactions are rolled back and the sessions get terminated.D The sessions are not allowed to perform any operations till the listener is started.

考题 单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command:LSNRCTL STOP What happens to the sessions that are presently connected to the database instance()A The sessions are able to perform only queries.B The sessions are not affected and continue to function normally.C The sessions are terminated and the active transactions are rolled back.D The sessions are not allowed to perform any operations till the listener is started

考题 单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command:  LSNRCTL STOP  What happens to the sessions that are presently connected to the database instance()A The sessions are able to perform only queries.B The sessions are not affected and continue to function normally.C The sessions are terminated and the active transactions are rolled back.D The sessions are not allowed to perform any operations till the listener is started.

考题 单选题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.

考题 单选题当前数据库运行在open状态,LISTENER也正常运行,此刻一个dba执行如下命令LSNRCTLSTOP下面的描述中那个是正确的?()A 会话只能执行查询操作B 连接的会话不允许做任何操作直到监听启动C 当前连接的会话不受影响,操作继续D 会话断掉,并且当前的事物回滚

考题 单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command:LSNRCTL STOP What happens to the sessions that are presently connected to the database instance()A The sessions are able to perform only queries.B The sessions are not affected and continue to function normally.C The sessions are terminated and the active transactions are rolled back.D The sessions are not allowed to perform any operations till the listener is started

考题 单选题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

考题 单选题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.