单选题Which are required initialization parameters in an Oracle Shared Server environment？（）ADISPATCHERS and SHARED_SERVERSBDISPATCHERS and MAX_DISPATCHERSCMAX_DISPATCHERS and MAX_SHARED_SERVERSDSHARED_SERVER_SESSIONS and DISPATCHERS
单选题
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
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？（）Awhen performing export and import using Oracle Data PumpBwhen performing backup and recovery operations using Oracle Recovery ManagerCwhen performing batch processing and bulk loading operation in a data warehouse environment Din 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？（）AMAX_DISPATCHERSBDISPATCHERSCMIN_DISPATCHERSDSHARED_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？（）AINIT.ORABSQLNET.ORACTNSNAMES.ORADSERVICES.ORAELISTENER.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 parameterAb, d, e, a, cBe, a, b, c, dCd, c, b, e, aDa, b, d, c, eEd, 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？（）AA dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. BUnder the Oracle Shared Server architecture, client-user processes connect to shared user processes.CEach dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. DOracle 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？ （）AOracle Net ServiceBOracle HTTP ServiceCOracle Paging ServiceDInternet 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？（）AThe PMON process registers the request in the response queue.BA shared sever places the process request in the response queue.CA request within the request queue is processed by an idle shared server process.DA 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 parameterAb, d, e, a, cBe, a, b, c, dCd, c, b, e, aDa, b, d, c, eEd, c, b, a, e