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

题目内容(请给出正确答案)

单选题

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（）

The sessions are able to perform only queries.

The sessions are not affected and continue to function normally.

The sessions are terminated and the active transactions are rolled back.

The sessions are not allowed to perform any operations till the listener is started

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

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

点击查看答案
第2题

单选题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 utilityB by using the STATUS L1 command of the Listener control utilityC by using the SHOW RULES command of the Listener control utilityD by using the SET PASSWORD command of the Listener control utilityE by searching for the PASSWORD_LISTENER entry in the listener.ora file

点击查看答案
第3题

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

点击查看答案
第4题

多选题You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

点击查看答案
第5题

单选题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 ManagerB Listener Control utilityC Database Configuration AssistantD Oracle Net Configuration Assistant

点击查看答案
第6题

单选题The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl What could be the reason for this?（）A The listener is not running on the database node.B The TNS_ADMIN environment variable is set to the wrong value.C The orcl.oracle.com database service is not registered with the listener.D The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E The listener is running on a different port.

点击查看答案
第7题

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

点击查看答案

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

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容