单选题You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achi

题目
单选题
You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this?()
A

Enable instance failover

B

Configure shared server

C

Enable database failover

D

Enable connect-time failover

E

Enable Transparent Application Failover (TAF)


相似考题
更多“单选题You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achi”相关问题
  • 第1题:

    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 Manager
    • B、Listener Control utility
    • C、Database Configuration Assistant
    • D、Oracle Net Configuration Assistant

    正确答案:B

  • 第2题:

    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 utility
    • B、 by using the STATUS L1 command of the Listener control utility
    • C、 by using the SHOW RULES command of the Listener control utility
    • D、 by using the SET PASSWORD command of the Listener control utility
    • E、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

    正确答案:B

  • 第3题:

    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.

    正确答案:C,E

  • 第4题:

    You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error: ERROR:   ORA-12154:TNS:couldnot resolve service name   Which network configuration files would you look into to resolve this error?()

    • A、snmp.ora
    • B、names.ora
    • C、spfile.ora
    • D、sqlnet.ora
    • E、listener.ora
    • F、tnsnames.ora

    正确答案:D,F

  • 第5题:

    You work as a database administrator for Supportcenter.cn. Your listener process, L1, is currently listening to three databases: CertK INDB04, SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant (DBCA) you create one more database, SupportCenter DB07, and enable dynamic registration. Which two commands of Listener Control Utility (lsnrct1) would you use to determine whether the dynamic registration occurred for the database, SupportCenter DB07, with the L1 listener process?()

    • A、SHOW L1
    • B、SPAWN L1
    • C、STATUS L1
    • D、SERVICES L1
    • E、STATUS LISTENER
    • F、SERVICES LISTENER
    • G、SHOWcurrent_listener

    正确答案:C,E

  • 第6题:

    You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()

    • A、Information about each Oracle Net connection.
    • B、Information about each entry in theLinstener.orafile
    • C、Information about the changed done in the database
    • D、Information about the different listeners in your system
    • E、Information about all thenondatabasefiles required to operate the database

    正确答案:A

  • 第7题:

    单选题
    You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()
    A

    ADDRESS_LIST

    B

    SID_NAME

    C

    LISTENER

    D

    SERVICE_LIST


    正确答案: A
    解析: 暂无解析

  • 第8题:

    单选题
    You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
    A

    Information about each Oracle Net connection.

    B

    Information about each entry in theLinstener.orafile

    C

    Information about the changed done in the database

    D

    Information about the different listeners in your system

    E

    Information about all thenondatabasefiles required to operate the database


    正确答案: A
    解析: 暂无解析

  • 第9题:

    单选题
    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?()
    A

     whether the password is set in the listener or a file or not

    B

     the number of client connections the service handler has refused

    C

     the information will be displayed whether the instance can accept connections or not

    D

     the protocol addresses on which the listener is configured to listen


    正确答案: B
    解析: 暂无解析

  • 第10题:

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


    正确答案: D,A
    解析: 暂无解析

  • 第11题:

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

    B

    by using the STATUS L1 command of the Listener control utility

    C

    by using the SHOW RULES command of the Listener control utility

    D

    by using the SET PASSWORD command of the Listener control utility

    E

    by searching for the PASSWORD_LISTENER entry in the listener.ora file


    正确答案: E
    解析: 暂无解析

  • 第12题:

    单选题
    You work as a database administrator for Certkiller .com. 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.  lsnrctl>START  What statement is true?()
    A

    It would attempt to start the default listener

    B

    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.


    正确答案: A
    解析: 暂无解析

  • 第13题:

    You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this?()

    • A、Enable instance failover
    • B、Configure shared server
    • C、Enable database failover
    • D、Enable connect-time failover
    • E、Enable Transparent Application Failover (TAF)

    正确答案:D

  • 第14题:

    You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()

    • A、ADDRESS_LIST
    • B、SID_NAME
    • C、LISTENER
    • D、SERVICE_LIST

    正确答案:B

  • 第15题:

    You work as a database administrator for Certkiller .com. 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.  lsnrctl>START  What statement is true?()

    • A、It would attempt to start the default listener
    • B、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.

    正确答案:A

  • 第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?() 

    • A、 whether the password is set in the listener or a file or not
    • B、 the number of client connections the service handler has refused
    • C、 the information will be displayed whether the instance can accept connections or not
    • D、 the protocol addresses on which the listener is configured to listen

    正确答案:B

  • 第17题:

    You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error: ERROR:  ORA-12154:TNS:couldnot resolve service name  Which network configuration files would you look into to resolve this error?()

    • A、snmp.ora
    • B、names.ora
    • C、spfile.ora
    • D、sqlnet.ora
    • E、listener.ora
    • F、tnsnames.ora

    正确答案:D,F

  • 第18题:

    单选题
    You work as a database administrator for Supportcenter.cn. You are using three database, SupportCenter DB01, SupportCenter DB02, and SupportCenter DB03, on different host machines in your development environment. The database server configuration, such as IP address and listener port number, change frequently due to development requirements, and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead?()
    A

    Host naming

    B

    Local naming

    C

    Easy Connect

    D

    External naming

    E

    directory naming


    正确答案: C
    解析: 暂无解析

  • 第19题:

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

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


    正确答案: D
    解析: 暂无解析

  • 第20题:

    单选题
    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.   lsnrctl>START   What statement is true?()
    A

    It would attempt to start the default listener

    B

    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.


    正确答案: B
    解析: 暂无解析

  • 第21题:

    单选题
    You work as a database administrator for Certkiller .com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this?()
    A

    Enable instance failover

    B

    Configure shared server

    C

    Enable database failover

    D

    Enable connect-time failover

    E

    Enable Transparent Application Failover (TAF)


    正确答案: C
    解析: 暂无解析

  • 第22题:

    多选题
    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?()
    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.


    正确答案: C,E
    解析: 暂无解析

  • 第23题:

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


    正确答案: A,B
    解析: 暂无解析