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

题目内容 (请给出正确答案)

Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener, database, and the configuration of the application. How would you avoid this scenario?()

  • A、lock the listener
  • B、hide the listener
  • C、create multiple listeners
  • D、run listener on a remote client
  • E、set a password for the listener
  • F、store listener.ora in a non-default location

参考答案

更多 “Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener, database, and the configuration of the application. How would you avoid this scenario?()A、lock the listenerB、hide the listenerC、create multiple listenersD、run listener on a remote clientE、set a password for the listenerF、store listener.ora in a non-default location” 相关考题
考题 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.

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

考题 You have just run this syntax to start the listener from the Listener Control utility:   LSNRCTLSTART   Starting /mstgelai/oracle/bin/tnslsnr: please wait…  System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521))) Connecting to…  The command completed successfully   What is the name of the Listener you started?()A、TNSLSNRB、LISTENERC、LOCAL_LISTENERD、DEFAULT_LSRN

考题 You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error:   ERROR:   ORA-12541:TNS:no_listener   You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener.   lsnrctlSTART   What statement is true?()A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.

考题 Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:  LSNRCTL STOP  What would happen 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 active transactions are rolled back and the sessions get terminated.D、The sessions are not allowed to perform any operations till the listener is started.

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

考题 You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?()A、 by using the STATUS command of the Listener control utilityB、 by using the STATUS L1 command of the Listener control utilityC、 by using the SHOW RULES command of the Listener control utilityD、 by using the SET PASSWORD command of the Listener control utilityE、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

考题 You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()A、 Use the CHANGE_PASSWORD command of the Listener control utility.B、 Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.C、 Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.D、 Manually modify the listener.ora file to include the password for the listener and restart the listener.

考题 In a shared server configuration, which two describe the actions that the listener can take to service a client request?()A、The listener hands the connection request directly to a dispatcher. B、A dedicated server inherits the connection request from the listener. C、The client connects to a dedicated server directly using a protocol address provided by the listener. D、The application initiating the session spawns a dedicated server process for the connection request. E、The listener issues a redirect message to the client, containing the protocol address of a dispatcher. The client then terminates the network session to the listener and establishes a network session to the dispatcher, using the network address provided in the redirect message. 

考题 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 three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control?()A、the port used by the listenerB、the protocol used by the listenerC、the server name where the listener runsD、the log file and trace file destination for the listenerE、the database services to be registered with the listener

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

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

考题 单选题Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:  LSNRCTL STOP  What would happen 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 active transactions are rolled back and the sessions get terminated.D The sessions are not allowed to perform any operations till the listener is started.

考题 单选题You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error:   ERROR:   ORA-12541:TNS:no_listener   You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener.   lsnrctlSTART   What statement is true?()A It would attempt to start the default listenerB It would start the most recently created listener.C It would display an error with a message asking for the listener name to be specified.D It would show you a list of listeners and prompts for the listener name that you want to start.

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

考题 单选题You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()A STARTB RELOADC RESTARTD REFRESHE START L1F RELOAD L1G RESTART L1H REFRESH L1

考题 单选题Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener, database, and the configuration of the application. How would you avoid this scenario?()A lock the listenerB hide the listenerC create multiple listenersD run listener on a remote clientE set a password for the listenerF store listener.ora in a non-default location

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

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

考题 单选题You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?()A by using the STATUS command of the Listener control utilityB by using the STATUS L1 command of the Listener control utilityC by using the SHOW RULES command of the Listener control utilityD by using the SET PASSWORD command of the Listener control utilityE by searching for the PASSWORD_LISTENER entry in the listener.ora file

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

考题 多选题Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control?()Athe port used by the listenerBthe protocol used by the listenerCthe server name where the listener runsDthe log file and trace file destination for the listenerEthe database services to be registered with the listener

考题 单选题You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()A  Use the CHANGE_PASSWORD command of the Listener control utility.B  Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.C  Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.D  Manually modify the listener.ora file to include the password for the listener and restart the listener.