Answer: B

深蓝浅析：

客户端连接数据库，使用local naming method的方式，官方文档中明确的指出了。因为tnsnames.ora文件是需要在客户端连接端使用的文件。

题号：132.

The tnsnames.ora file has an entry for the service alias ORCL as follows:

ORCL =

( DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl.oracle.com)

)

)

The TNSPING command executes successfully when tested with ORCL, but 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 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.

Answer: C

深蓝浅析：

tnsping通代表对tnsnames.ora的解析是成功的，但如果tnsnames.ora中的service_name没有注册到listener.ora中去，仍然是不能连接数据库的。

题号：133.

Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener 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.

Answer: B

深蓝浅析：

监听只有在建立连接时才起作用，连接建立后，监听就完成了使命，之后的任务都交给了server process了。可以参看问题4。

题号：134.

View the Exhibit and examine the output.

?

Which two statements are true regarding the LISTENER2 listener? (Choose two.)

A.The ORCL instance is registered dynamically with the listener.

B.The ORCL instance is registered statically in the listener.ora file.

C.The number of current client connections handled by the service handler is two.

D.The total number of client connections handled so far by the service handler is two.

Answer: BD

深蓝浅析：

通过UNKNOWN可以知道这是静态注册，参考问题19，因此选B。通过established为2可以知道，目前建立了两个连接，因此选D。

题号：135.

In which situation would you use static database registration for a listener?

A.when multiple databases are to be registered with the listener

B.when DBAs need to connect remotely to start up the database instance

C.when users need to connect the database instance using the host naming method

D.when the database instance that is to be registered with the listener is configured in shared server mode

Answer: B

深蓝浅析：

为了实现远程启动数据库实例，此时需要通过静态数据库注册来完成连接数据库，因此选B。

题号：136.

You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for cross-verification.

Which schema object enables the user to access the information from the remote database?

A.Cluster

B.Database link

C.Mapping table

D.Materialized view

Answer: B

深蓝浅析：

为了实现两个数据库数据的关联，这里需要使用Database link。

题号：137.

Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously. Some users of the Web application do not interact with the server all the time.