单选题Which are required initialization parameters in an Oracle Shared Server environment？（）A DISPATCHERS and SHARED_SERVERSB DISPATCHERS and MAX_DISPATCHERSC MAX_DISPATCHERS and MAX_SHARED_SERVERSD SHARED_SERVER_SESSIONS and DISPATCHERS

第1题：

NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracle‟s order of precedence: （） a. Default setting b. Client environment variable c. Explicit ALTER SESSION statement d. Inside SQL function e. Server initialization parameter

• A、b, d, e, a, c
• B、e, a, b, c, d
• C、d, c, b, e, a
• D、a, b, d, c, e
• E、d, c, b, a, e

第2题：

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.

第3题：

Which are required initialization parameters in an Oracle Shared Server environment？（）

• A、DISPATCHERS and SHARED_SERVERS
• B、DISPATCHERS and MAX_DISPATCHERS
• C、MAX_DISPATCHERS and MAX_SHARED_SERVERS
• D、SHARED_SERVER_SESSIONS and DISPATCHERS

第4题：

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）

• A、 DB_CACHE_SIZE
• B、 SHARED_POOL_SIZE
• C、 LARGE_POOL_SIZE
• D、 JAVA_POOL_SIZE
• E、 SGA_MAX_SIZE
• F、 SORT_AREA_SIZE

第5题：

Which of the following parameters must be specified to define the number of dispatchers that need to be started？（）

• A、MAX_DISPATCHERS
• B、DISPATCHERS
• C、MIN_DISPATCHERS
• D、SHARED_SERVERS

第6题：

Click the Exhibit button and examine the diagram， which illustrates the components performing tasks within an Oracle Shared Sever environment. Which task is being performed by component 4？（）

• A、The PMON process registers the request in the response queue.
• B、A shared sever places the process request in the response queue.
• C、A request within the request queue is processed by an idle shared server process.
• D、A dispatcher assigns a request from the request queue to and idle shared server process.

第7题：

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)

• A、The databases configured to use the ASM instance are mounted
• B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
• C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
• D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

第8题：

You are configuring for Oracle Shared Server. Which service is required？ （）

• A、Oracle Net Service
• B、Oracle HTTP Service
• C、Oracle Paging Service
• D、Internet Directory Service

第9题：

Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（）   The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set  

• A、 then the default is set to $ORACLE_BASE  The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，
• B、 then it is set to $ORACLE_HOME
• C、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOME
• D、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE

第10题：

You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）

• A、 INSTANCE_TYPE
• B、 DB_UNIQUE_NAME
• C、 ASM_DISKSTRING
• D、 ASM_POWER_LIMIT