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

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

相似考题

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

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

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

4.Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

更多“单选题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 ”相关问题

  • 第1题：

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

    正确答案:B

  • 第2题：

    our 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 Manager
    • B、Listener Control utility
    • C、Database Configuration Assistant
    • D、Oracle Net Configuration Assistant

    正确答案:B

  • 第3题：

    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

  • 第4题：

    You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）

    • A、More than one database is to be registered with the listener.
    • B、The users will connect the database by using the host naming method.
    • C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
    • D、The database that is to be registered with the listener is configured in shared server mode.
    • E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

    正确答案:C,E

  • 第5题：

    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 Manager
    • B、Listener Control utility
    • C、Database Configuration Assistant
    • D、Oracle Net Configuration Assistant

    正确答案:B

  • 第6题：

    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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第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题：

    单选题
    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
    解析： 暂无解析

  • 第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题：

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

    B

    Listener Control utility

    C

    Database Configuration Assistant

    D

    Oracle Net Configuration Assistant


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

  • 第13题：

    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.

    正确答案:B

  • 第14题：

    All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands （）

    • A、all sessions of the HR user only
    • B、all sessions of the HR user and the SYS user
    • C、the session of the HR user that executed the commands
    • D、all the sessions for which the database users have access privilege to the PERSONS table

    正确答案:C

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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 Manager
    • B、 Listener Control utility
    • C、 Database Configuration Assistant
    • D、 Oracle Net Configuration Assistant

    正确答案:B

  • 第18题：

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

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


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

  • 第19题：

    单选题
    You are a Database Administrator with TXGlobal. You use a password file to establish remote connections to the HR database on the server located at the home office. Currently， two active remote sessions exist to this database. These sessions were established using the SYSDBA privilege from the remote machines. You accidentally deleted the password file. What will be the consequence of this action？（）
    A

     Both the sessions will be killed， and no new sessions will be created using the SYSDBA or SYSOPER privilege.

    B

     Both the sessions will remain active， but no new sessions will be created using the SYSDBA or SYSOPER privilege.

    C

    Both the sessions will be killed， but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.

    D

     The database will crash， and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）
    A

    All sessions of the HR user only

    B

    All sessions of the HR user and the SYS user

    C

    The session of the HR user that executed the commands

    D

    All the sessions for which the database users have access privilege to the PERSONS table


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

  • 第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 plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）
    A

    More than one database is to be registered with the listener.

    B

    The users will connect the database by using the host naming method.

    C

    The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.

    D

    The database that is to be registered with the listener is configured in shared server mode.

    E

    The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.


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

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容