单项选择题

A.ClusterB.Database linkC.Mapping tableD.Materialized v……

You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee 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 accountspayable 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

<上一题目录下一题>

热门试题

单项选择题Inwhichsituationwouldyouusestaticdatabaseregistrationforalistener（）

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

多项选择题View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener（）

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.

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