单项选择题

A.The sessions are able to perform only queries.B.The s……

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.

<上一题目录下一题>

热门试题

单项选择题What could be the reason for this（）

A.The listener is not running on the database node.
B.The TNS_ADMIN environmental variable is set to a wrong value.
C.The orcl.oracle.com database service is not registered with the listener.
D.The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.

单项选择题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine（）

A.host naming method
B.local naming method
C.external naming method
D.directory naming method

多项选择题Whichtwostatementsaretrueregardinglisteners（）

A.Listeners use only the TCP/IP protocol.
B.Multiple listener processes can run simultaneously on a host.
C.Multiple database instances can be registered with a single listener.
D.The listener-related errors can be traced only at the administrative level.
E.Only one database instance can be registered with a single listener at any time.

多项选择题A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith smith Connected. SQL> SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

A.granting SELECT privilege to SMITH on V$SESSION
B.granting SELECT privilege to SMITH on V_$SESSION
C.asking the user SMITH to run the catalog.sql script
D.granting SELECT privilege to SMITH on V$FIXED_TABLES
E.setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
F.creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

单项选择题Note the points about data dictionary views and dynamic performance views： 1.These are stored in the SYSTEM tablespace. 2.These are the based on the virtual tables. 3.These are owned by the SYSuser. 4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE. 5.V$FIXED_TABLE view can be queried to list the names of these views. Which statements listed describe the data dictionary views（）

A.1 and 3
B.2，3，and 5
C.1，2，and 3
D.2，3，4，and 5