网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
Which statement is true about Oracle Net Listener?()
A

It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

B

A single listener can service only one database instance and multiple remote client connections.

C

Service registration with the listener is performed by the process monitor (PMON) process of each database instance.

D

The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.


参考答案

参考解析
解析: 暂无解析
更多 “单选题Which statement is true about Oracle Net Listener?()A It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.B A single listener can service only one database instance and multiple remote client connections.C Service registration with the listener is performed by the process monitor (PMON) process of each database instance.D The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.” 相关考题
考题 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

考题 Which statement is true about Oracle Net Listener?() A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.B. A single listener can service only one database instance and multiple remote client connections.C. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

考题 Which statement is true regarding Dynamic Service Registration?()A、Dynamic service registration requires configuration in the listener .ora file.B、Dynamic service registration can be used only with an Oracle9/instance.C、Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.D、The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.

考题 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.

考题 Which  statements are true regarding listeners()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

考题 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

考题 The listener uses dynamic information about the database and instance it has received through service registration before using information statically configured. Some services such as heterogeneous services and external procedures require the use of information statically configured within listener.ora. In order to support this, which tool could be used to configure the listener statically?()A、Oracle Net ManagerB、Listener Control UtilityC、Oracle Net Control UtilityD、Oracle Net Configuration Assistant

考题 Which two statements are true regarding hot patching?()A、 It requires relinking of the Oracle binary.B、 It does not require database instance shutdown.C、 It can detect conflicts between two online patches.D、 It is available for installing all patches on all platforms. E、 It works only in a single database instance environment.

考题 Which statement is true regarding Oracle Shared Server architecture?()A、A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. B、Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.C、Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. D、Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.

考题 A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance?()A、Data PumpB、Oracle Net ManagerC、Oracle Enterprise ManagerD、Oracle Universal Installer (OUI)E、Database Configuration Assistant (DBCA)

考题 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.

考题 You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command:   LSNRCTLSTATUS listener1   Which information will NOT be displayed when you issue the above command?() A、 whether the password is set in the listener or a file or notB、 the number of client connections the service handler has refusedC、 the information will be displayed whether the instance can accept connections or notD、 the protocol addresses on which the listener is configured to listen

考题 Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

考题 Which two statements are true regarding listeners()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.

考题 Which statement is true regarding remote archive log file destinations?()A、Only two destinations per remote database can be specified.B、Destination is an Oracle Net alias specified by using the SERVICE keyword.C、The REOPEN attribute must be used when using remote archive log file destinations.D、The service name is resolved by searching sqlnet.ora file for the remote database name.

考题 多选题Which  statements are true regarding listeners()AListeners use only the TCP/IP protocol.BMultiple listener processes can run simultaneously on a host.CMultiple database instances can be registered with a single listener.DThe listener-related errors can be traced only at the administrative level.EOnly one database instance can be registered with a single listener at any time

考题 单选题Which statement is true about Oracle Net Listener?()A It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.B A single listener can service only one database instance and multiple remote client connections.C Service registration with the listener is performed by the process monitor (PMON) process of each database instance.D The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

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

考题 单选题You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command:   LSNRCTLSTATUS listener1   Which information will NOT be displayed when you issue the above command?()A  whether the password is set in the listener or a file or notB  the number of client connections the service handler has refusedC  the information will be displayed whether the instance can accept connections or notD  the protocol addresses on which the listener is configured to listen

考题 单选题Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?()A PMONB SMONC LGWRD CKRT

考题 多选题Which two statements are true regarding hot patching? ()AIt requires relinking of the Oracle binary.BIt does not require database instance shutdown.CIt can detect conflicts between two online patches.DIt is available for installing all patches on all platforms.EIt works only in a single database instance environment.

考题 多选题You work as a database administrator for Certkiller .com. 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?()AIt gets it from the parameter file.BThe listener prompts for details on startup.CThe listener gathers information from the control file.DThe instance automatically registers with the default listener.EThe listener gets this information through thelistener.orafile.

考题 单选题Which statement is true regarding Oracle Shared Server architecture?()A A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. B Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.C Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. D Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.

考题 多选题You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb  Which three statements are correct regarding the connection string?()Amydb is a service name.Btest.us.oracle.com is a database name.C1521 is the listener port number.Dmydb is a host name.Etest.us.oracle.com is a net service name.Fhr is a username.Gtest.us.oracle.com is an instance name.

考题 单选题Which statement is true regarding Dynamic Service Registration?()A Dynamic service registration requires configuration in the listener .ora file.B Dynamic service registration can be used only with an Oracle9/instance.C Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.D The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.

考题 多选题Which two statements are true regarding listeners()AListeners use only the TCP/IP protocol.BMultiple listener processes can run simultaneously on a host.CMultiple database instances can be registered with a single listener.DThe listener-related errors can be traced only at the administrative level.EOnly one database instance can be registered with a single listener at any time.

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

考题 单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()A When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.