It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
A single listener can service only one database instance and multiple remote client connections.
Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
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.
第1题:
Which statements are true regarding listeners()
第2题:
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?()
第3题:
Which statement is true regarding Oracle Shared Server architecture?()
第4题:
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this?()
第5题:
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?()
第6题:
Which statement is true regarding remote archive log file destinations?()
第7题:
It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
A single listener can service only one database instance and multiple remote client connections.
Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
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.
第8题:
whether the password is set in the listener or a file or not
the number of client connections the service handler has refused
the information will be displayed whether the instance can accept connections or not
the protocol addresses on which the listener is configured to listen
第9题:
It requires relinking of the Oracle binary.
It does not require database instance shutdown.
It can detect conflicts between two online patches.
It is available for installing all patches on all platforms.
It works only in a single database instance environment.
第10题:
A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher.
Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.
Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher.
Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.
第11题:
Dynamic service registration requires configuration in the listener .ora file.
Dynamic service registration can be used only with an Oracle9/instance.
Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.
The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.
第12题:
Oracle Net Manager
Listener Control utility
Database Configuration Assistant
Oracle Net Configuration Assistant
第13题:
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?()
第14题:
Which two statements are true regarding hot patching?()
第15题:
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?()
第16题:
You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command: LSNRCTL>STATUS listener1 Which information will NOT be displayed when you issue the above command?()
第17题:
Which two statements are true regarding listeners()
第18题:
Listeners use only the TCP/IP protocol.
Multiple listener processes can run simultaneously on a host.
Multiple database instances can be registered with a single listener.
The listener-related errors can be traced only at the administrative level.
Only one database instance can be registered with a single listener at any time
第19题:
Oracle Net Manager
Listener Control utility
Database Configuration Assistant
Oracle Net Configuration Assistant
第20题:
PMON
SMON
LGWR
CKRT
第21题:
It gets it from the parameter file.
The listener prompts for details on startup.
The listener gathers information from the control file.
The instance automatically registers with the default listener.
The listener gets this information through thelistener.orafile.
第22题:
mydb is a service name.
test.us.oracle.com is a database name.
1521 is the listener port number.
mydb is a host name.
test.us.oracle.com is a net service name.
hr is a username.
test.us.oracle.com is an instance name.
第23题:
Listeners use only the TCP/IP protocol.
Multiple listener processes can run simultaneously on a host.
Multiple database instances can be registered with a single listener.
The listener-related errors can be traced only at the administrative level.
Only one database instance can be registered with a single listener at any time.
第24题:
When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.