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

题目

单选题

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

DISPATCHERS and SHARED_SERVERS

DISPATCHERS and MAX_DISPATCHERS

MAX_DISPATCHERS and MAX_SHARED_SERVERS

SHARED_SERVER_SESSIONS and DISPATCHERS

相似考题

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

2. 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 parameterA、b, d, e, a, cB、e, a, b, c, dC、d, c, b, e, aD、a, b, d, c, eE、d, c, b, a, e

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

4.You are configuring for Oracle Shared Server. Which service is required？（）A、Oracle Net ServiceB、Oracle HTTP ServiceC、Oracle Paging ServiceD、Internet Directory Service

更多“单选题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题：

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
第2题：

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
正确答案:B
第3题：

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
正确答案:A,B,C,D
第4题：

In which situation would you use the Oracle Shared Server configuration？（）
- A、when performing export and import using Oracle Data Pump
- B、when performing backup and recovery operations using Oracle Recovery Manager
- C、when performing batch processing and bulk loading operation in a data warehouse environment
- D、in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
正确答案:D
第5题：

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?（）
- 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
正确答案:B,C
第6题：

单选题
In which situation would you use the Oracle Shared Server configuration？（）
A
when performing export and import using Oracle Data Pump
B
when performing backup and recovery operations using Oracle Recovery Manager
C
when performing batch processing and bulk loading operation in a data warehouse environment
D
in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

正确答案： D
解析：暂无解析
第7题：

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

正确答案： B
解析：暂无解析
第8题：

单选题
Which of the following files can be used to configure connection pooling in the shared server environment？（）
A
INIT.ORA
B
SQLNET.ORA
C
TNSNAMES.ORA
D
SERVICES.ORA
E
LISTENER.ORA

正确答案： C
解析：暂无解析
第9题：

多选题
Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）
A
set SHARED_POOL_SIZE to zero
B
set STATISTICS_LEVEL to BASIC
C
set SGA_TARGET to a non-zero value
D
set DB_CACHE_SIZE to a non-zero value
E
set STATISTICS_LEVEL to TYPICAL or ALL

正确答案： A,B
解析：暂无解析
第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

正确答案： C
解析：暂无解析
第11题：

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

正确答案： A
解析：暂无解析
第12题：

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

正确答案： B
解析：暂无解析
第13题：

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
正确答案:B,C
第14题：

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
正确答案:B
第15题：

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
正确答案:A
第16题：

Which server stack communication layer corresponds to the client application layer in a distributed environment？（）
- A、RDBMS
- B、Application
- C、Oracle Net foundation
- D、Network Protocol
- E、Presentation
正确答案:A
第17题：

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

正确答案： C,A
解析：暂无解析
第18题：

多选题
You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement： SQL> SELECT name， value， isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’； The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply？（）
A
The SGA_TARGET initialization parameter cannot be set to a value less than 1G
B
The SGA_TARGET initialization parameter cannot be set to a value greater than 1G
C
The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA
D
The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.
E
No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.
F
The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.

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

多选题
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（）
A
BACKGROUND_DUMP_DEST
B
FOREGROUND_DUMP_DEST
C
CORE_DUMP_DEST
D
USER_DUMP_DEST
E
DIAGNOSTIC_DEST
F
All of the above

正确答案： B,E
解析：暂无解析
第20题：

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

正确答案： B
解析：暂无解析
第21题：

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

正确答案： D
解析：暂无解析
第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题：

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

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

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

题目

相似考题

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

相关内容