多选题Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?（）AThread creation must be routed through a dispatcher processBThe local listener may spawn

题目
多选题
Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?（）
A

Thread creation must be routed through a dispatcher process

B

The local listener may spawn a now process and have that new process create a thread

C

Each Oracle process runs an SCMN thread.

D

Each multithreaded Oracle process has an SCMN thread.

E

The local listener may pass the request to an existing process which in turn will create a thread.

相似考题

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

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

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

4.Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?()A. Thread creation must be routed through a dispatcher processB. The local listener may spawn a now process and have that new process create a threadC. Each Oracle process runs an SCMN thread.D. Each multithreaded Oracle process has an SCMN thread.E. The local listener may pass the request to an existing process which in turn will create a thread.

更多“多选题Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?（）AThread creation must be routed through a dispatcher processBThe local listener may spawn ”相关问题

  • 第1题：

    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,E

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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？（）

    • A、mydb is a service name.
    • B、test.us.oracle.com is a database name.
    • C、1521 is the listener port number.
    • D、mydb is a host name.
    • E、test.us.oracle.com is a net service name.
    • F、hr is a username.
    • G、test.us.oracle.com is an instance name.

    正确答案:A,C,F

  • 第5题：

    The direct handoff connection method to an Oracle9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture. Which type of message has been eliminated？（）

    • A、The initial request from the client to the listener.
    • B、Messages between the dispatcher and the shared server background processes.
    • C、A redirect message from the listener to the client during client connections.
    • D、Round-trip messages between the listener and the shared server background processes.

    正确答案:C

  • 第6题：

    Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?（）

    • A、Thread creation must be routed through a dispatcher process
    • B、The local listener may spawn a now process and have that new process create a thread
    • C、Each Oracle process runs an SCMN thread.
    • D、Each multithreaded Oracle process has an SCMN thread.
    • E、The local listener may pass the request to an existing process which in turn will create a thread.

    正确答案:A,D,E

  • 第7题：

    Which of the following statements about variables and their scopes are true？ （）   

    • A、 Instance variables are member variables of a class.
    • B、 Instance variables are declared with the static keyword.
    • C、 Local variables defined inside a method are created when the method is executed.
    • D、 Local variables must be initialized before they are used.

    正确答案:A,C,D

  • 第8题：

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

  • 第9题：

    多选题
    Which three statements are true about the privileged connection options available in Oracle9i？（）
    A

    The CONNECT INTERNAL is disallowed.

    B

    The Server Manager tool is no longer supplied.

    C

    The listener must be running to make a connection.

    D

    The use of remote password login file (orapw<sid>) is unchanged.


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

  • 第10题：

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

  • 第11题：

    多选题
    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？（）
    A

    mydb is a service name.

    B

    test.us.oracle.com is a database name.

    C

    1521 is the listener port number.

    D

    mydb is a host name.

    E

    test.us.oracle.com is a net service name.

    F

    hr is a username.

    G

    test.us.oracle.com is an instance name.


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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

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

    正确答案:A

  • 第15题：

    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.

    正确答案:D

  • 第16题：

    Which three statements are true about the privileged connection options available in Oracle9i？（）

    • A、The CONNECT INTERNAL is disallowed. 
    • B、The Server Manager tool is no longer supplied. 
    • C、The listener must be running to make a connection. 
    • D、The use of remote password login file (orapw<sid>) is unchanged.

    正确答案:A,B,C

  • 第17题：

    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. 

    正确答案:A,E

  • 第18题：

    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

  • 第19题：

    多选题
    Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?（）
    A

    Reduced logical I/O

    B

    Reduced virtual memory utilization

    C

    Improved parallel Execution performance

    D

    Improved Serial Execution performance

    E

    Reduced physical I/O

    F

    Reduced CPU utilization


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

  • 第20题：

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

  • 第21题：

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

  • 第22题：

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


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

  • 第23题：

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


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

相关内容