网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
参考答案
参考解析
解析:
暂无解析
更多 “单选题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
考题
You are configuring for Oracle Shared Server. Which service is required? ()A、Oracle Net ServiceB、Oracle HTTP ServiceC、Oracle Paging ServiceD、Internet Directory Service
考题
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
考题
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.
考题
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.
考题
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 mountedB、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
Which of the following parameters must be specified to define the number of dispatchers that need to be started?()A、MAX_DISPATCHERSB、DISPATCHERSC、MIN_DISPATCHERSD、SHARED_SERVERS
考题
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_HOMEC、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOMED、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
考题
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_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
考题
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_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
考题
In which situation would you use the Oracle Shared Server configuration?()A、when performing export and import using Oracle Data PumpB、when performing backup and recovery operations using Oracle Recovery ManagerC、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
考题
Which server stack communication layer corresponds to the client application layer in a distributed environment?()A、RDBMSB、ApplicationC、Oracle Net foundationD、Network ProtocolE、Presentation
考题
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 mountedB、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
多选题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.)AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
单选题In which situation would you use the Oracle Shared Server configuration?()A
when performing export and import using Oracle Data PumpB
when performing backup and recovery operations using Oracle Recovery ManagerC
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
考题
多选题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?()AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters.FThe 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.
考题
单选题Which of the following parameters must be specified to define the number of dispatchers that need to be started?()A
MAX_DISPATCHERSB
DISPATCHERSC
MIN_DISPATCHERSD
SHARED_SERVERS
考题
多选题Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository?()ABACKGROUND_DUMP_DESTBFOREGROUND_DUMP_DESTCCORE_DUMP_DESTDUSER_DUMP_DESTEDIAGNOSTIC_DESTFAll of the above
考题
单选题Which of the following files can be used to configure connection pooling in the shared server environment?()A
INIT.ORAB
SQLNET.ORAC
TNSNAMES.ORAD
SERVICES.ORAE
LISTENER.ORA
考题
单选题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 setA
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_HOMEC
DIAGNOSTIC_DEST is always equal to $ORACLE_HOMED
DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
考题
多选题Which two initialization parameters would you set to enable Automatic Shared Memory Management?()Aset SHARED_POOL_SIZE to zeroBset STATISTICS_LEVEL to BASICCset SGA_TARGET to a non-zero valueDset DB_CACHE_SIZE to a non-zero valueEset STATISTICS_LEVEL to TYPICAL or ALL
考题
单选题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
考题
单选题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_TYPEB
DB_UNIQUE_NAMEC
ASM_DISKSTRINGD
ASM_POWER_LIMIT
考题
单选题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.
考题
单选题You are configuring for Oracle Shared Server. Which service is required? ()A
Oracle Net ServiceB
Oracle HTTP ServiceC
Oracle Paging ServiceD
Internet Directory Service
考题
单选题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.
考题
单选题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
热门标签
最新试卷