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 logg

题目

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".
相似考题

1.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

2. 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.

3. You manually create an additional listener process，L1，for databases PROD，  PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1  Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please wait...  TNSLSNR for Linux： Version 10.1.0.2.0 - Production  System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on： （ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））  TNS-12542： TNS：address already in use TNS-12560：  TNS：protocol adapter error TNS-00512： Address already in use  Linux Error： 98： Address already in use  Listener failed to start. See the error message（s） above...  What action would you take to overcome this error without disrupting any existing database communications？（）A、stop and restart the listener processB、set the TNS_ADMIN environmental variableC、stop all running listener processes and restart the listener processD、change the port number to an unused port number and restart the listener processE、change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

4. You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.

参考答案和解析
正确答案:B
更多“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 loggin”相关问题

  • 第1题：

    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

    正确答案:B

  • 第2题：

    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.

    正确答案:D

  • 第3题：

    You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command：   LSNRCTL>STATUS listener1   Which information will NOT be displayed when you issue the above command？（） 

    • A、 whether the password is set in the listener or a file or not
    • B、 the number of client connections the service handler has refused
    • C、 the information will be displayed whether the instance can accept connections or not
    • D、 the protocol addresses on which the listener is configured to listen

    正确答案:B

  • 第4题：

    You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）

    • A、 executing the SET PASSWORD command and then the SAVE_CONFIG command
    • B、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command
    • C、 executing the CHANGE_PASSWORD command and then the SET PASSWORD command
    • D、 executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the  SAVE_CONFIG command

    正确答案:D

  • 第5题：

    You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）

    • A、START
    • B、RELOAD
    • C、RESTART
    • D、REFRESH
    • E、START L1
    • F、RELOAD L1
    • G、RESTART L1
    • H、REFRESH L1

    正确答案:F

  • 第6题：

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


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）
    A

    It would attempt to start the default listener

    B

    It would start the most recently created listener.

    C

    It would display an error with a message asking for the listener name to be specified.

    D

    It would show you a list of listeners and prompts for the listener name that you want to start.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command：   LSNRCTL>STATUS listener1   Which information will NOT be displayed when you issue the above command？（）
    A

     whether the password is set in the listener or a file or not

    B

     the number of client connections the service handler has refused

    C

     the information will be displayed whether the instance can accept connections or not

    D

     the protocol addresses on which the listener is configured to listen


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）
    A

    START

    B

    RELOAD

    C

    RESTART

    D

    REFRESH

    E

    START L1

    F

    RELOAD L1

    G

    RESTART L1

    H

    REFRESH L1


    正确答案： E
    解析： 暂无解析

  • 第10题：

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


    正确答案： C
    解析： 暂无解析

  • 第11题：

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


    正确答案： D
    解析： 暂无解析

  • 第12题：

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


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）

    • A、 by using the STATUS command of the Listener control utility
    • B、 by using the STATUS L1 command of the Listener control utility
    • C、 by using the SHOW RULES command of the Listener control utility
    • D、 by using the SET PASSWORD command of the Listener control utility
    • E、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

    正确答案:B

  • 第14题：

    You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective？（）

    • A、 Use the CHANGE_PASSWORD command of the Listener control utility.
    • B、 Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
    • C、 Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
    • D、 Manually modify the listener.ora file to include the password for the listener and restart the listener.

    正确答案:C

  • 第15题：

    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.

    正确答案:B

  • 第16题：

    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.

    正确答案:C

  • 第17题：

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


    正确答案： B
    解析： 暂无解析

  • 第18题：

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


    正确答案： D
    解析： 暂无解析

  • 第19题：

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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）
    A

     executing the SET PASSWORD command and then the SAVE_CONFIG command

    B

     executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command

    C

     executing the CHANGE_PASSWORD command and then the SET PASSWORD command

    D

     executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the  SAVE_CONFIG command


    正确答案： A
    解析： 暂无解析

  • 第21题：

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


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）
    A

    by using the STATUS command of the Listener control utility

    B

    by using the STATUS L1 command of the Listener control utility

    C

    by using the SHOW RULES command of the Listener control utility

    D

    by using the SET PASSWORD command of the Listener control utility

    E

    by searching for the PASSWORD_LISTENER entry in the listener.ora file


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    You have two listener processes， named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server， you find the following entry： PASSWORDS_L1 = （1sanfrjp43） What would be the impact of this setting？（）
    A

    The listener process named L1 will disconnect the unauthorized users.

    B

    The listener process named L1 will be prevented from being started by unauthorized users. 

    C

    The listener process named L1 will be prevented from being stopped by unauthorized users. 

    D

    The listener process named L1 will be prevented from being reloaded by unauthorized users.

    E

    The listener process named L1 will be prevented from accepting connections from unauthorized users.


    正确答案： E
    解析： 暂无解析

相关内容