单选题What could be the reason for this（）AThe listener is not running on the database node.BThe TNS_ADMIN environmental variable is set to a wrong value.CThe orcl.oracle.com database service is not registered with the listener.DThe DEFAULT_DOMAIN parameter i

题目
单选题
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.

相似考题

1.Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl >STOPWhat happens to the sessions that are presently connected to the database Instance?（）A. They are able to perform only queries.B. They are not affected and continue to function normally.C. They are terminated and the active transactions are rolled back.D. They are not allowed to perform any operations until the listener LISTENER is started

2.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.

3.You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）A、The source database backup must be copied over the net for test database.B、The source database must be run in ARCHIVELOG mode if the database is open.C、The source database must be shut down cleanly if the database is in mounted state.D、A net service name should be set up and a listener configured with the target as well as the source database.

4.The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL >CONNECT scott/tiger@orcl What could be the reason for this?（）A. The listener is not running on the database node.B. The TNS_ADMIN environment variable is set to the wrong value.C. The orcl.oracle.com database service is not registered with the listener.D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E. The listener is running on a different port.

更多“单选题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 par”相关问题

  • 第1题：

    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

    正确答案:B,C

  • 第2题：

    Your tnsnames.ora file has the following entry for the service alias ORCL：  ORCL =  （DESCRIPTION =  （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521））   （CONNECT_DATA =  （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com）   ）   ）   The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command：  SQL> CONNECT scott/tiger@orcl  What could be the reason for this？（）

    • A、The listener is not running at the server.
    • 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.

    正确答案:C

  • 第3题：

    The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl What could be the reason for this?（）

    • A、The listener is not running on the database node.
    • B、The TNS_ADMIN environment variable is set to the wrong value.
    • C、The orcl.oracle.com database service is not registered with the listener.
    • D、The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
    • E、The listener is running on a different port.

    正确答案:C

  • 第4题：

    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 listener
    • B、the protocol used by the listener
    • C、the server name where the listener runs
    • D、the log file and trace file destination for the listener
    • E、the database services to be registered with the listener

    正确答案:A,B,C

  • 第5题：

    You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）  

    • A、 The operating system local time zone will be set for a user session using the operating system environment variable.
    • B、 The database local time zone will be set for a user session using the operating system environment variable.
    • C、 The operating system local time zone will be set for the database using the operating system environment
    • D、 The database local time zone will be set for the database using the operating system environment variable.

    正确答案:B

  • 第6题：

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


    正确答案： B,C
    解析： 暂无解析

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）
    A

    ORA_PATH

    B

    ORACLE_SID

    C

    ORACLE_BASE

    D

    ORACLE_HOME

    E

    LD_LIBRARY_PATH


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

  • 第9题：

    单选题
    Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing 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


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

  • 第10题：

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


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

  • 第11题：

    多选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl What could be the reason for this?（）
    A

    The listener is not running on the database node.

    B

    The TNS_ADMIN environment variable is set to the wrong value.

    C

    The orcl.oracle.com database service is not registered with the listener.

    D

    The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

    E

    The listener is running on a different port.


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

  • 第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?（）

    • A、Oracle Net Manager
    • B、Listener Control utility
    • C、Database Configuration Assistant
    • D、Oracle Net Configuration Assistant

    正确答案:B

  • 第14题：

    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

  • 第15题：

    In which situation would you use static database registration for a listener（）

    • 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

    正确答案:B

  • 第16题：

    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.

    正确答案:B,C

  • 第17题：

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


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

  • 第18题：

    多选题
    You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）
    A

    The source database backup must be copied over the net for test database.

    B

    The source database must be run in ARCHIVELOG mode if the database is open.

    C

    The source database must be shut down cleanly if the database is in mounted state.

    D

    A net service name should be set up and a listener configured with the target as well as the source database.


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

  • 第19题：

    单选题
    Your tnsnames.ora file has the following entry for the service alias ORCL：  ORCL =  （DESCRIPTION =  （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521））   （CONNECT_DATA =  （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com）   ）   ）   The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command：  SQL> CONNECT scott/tiger@orcl  What could be the reason for this？（）
    A

    The listener is not running at the server.

    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.


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

  • 第20题：

    单选题
    You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）
    A

     The operating system local time zone will be set for a user session using the operating system environment variable.

    B

     The database local time zone will be set for a user session using the operating system environment variable.

    C

     The operating system local time zone will be set for the database using the operating system environment

    D

     The database local time zone will be set for the database using the operating system environment variable.


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

  • 第21题：

    单选题
    You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）
    A

    NLSLANG

    B

    NLSLENGTHSEMANTICS

    C

    NLSTERRITORY

    D

    NLSLANGUAGE

    E

    NLSCHARACTERSET

    F

    NLSDATELANGUAGE

    G

    NLSNCHARCHARACTERSET


    正确答案： G
    解析： 暂无解析

  • 第22题：

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


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

  • 第23题：

    单选题
    In which situation would you use static database registration for a listener（）
    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


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

  • 第24题：

    单选题
    Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?（）
    A

    They are able to perform only queries.

    B

    They are not affected and continue to function normally.

    C

    They are terminated and the active transactions are rolled back.

    D

    They are not allowed to perform any operations until the listener LISTENER is started


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

相关内容