网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process， the following tasks are performed： 1.A shared server picks up the request from the request queue and processes the request. 2.The dispatcher retrieves the response from the response queue. 3.A user sends a request to its dispatcher. 4.The dispatcher returns the response to the user. 5.The shared sever places the response on the calling dispatcher’s response queue. 6.The dispatcher places the request into the request queue in the SGA. Put the above task in the order in which they are performed.（）
A
3，1，6，2，5，4
B
3，6，1，5，2，4
C
3，1，2，3，4，5
D
6，1，3，5，2，4
E
6，3，1，2，4，5
F
6，3，1，2，5，4
参考答案
参考解析
解析：
暂无解析
更多 “单选题The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process， the following tasks are performed： 1.A shared server picks up the request from the request queue and processes the request. 2.The dispatcher retrieves the response from the response queue. 3.A user sends a request to its dispatcher. 4.The dispatcher returns the response to the user. 5.The shared sever places the response on the calling dispatcher’s response queue. 6.The dispatcher places the request into the request queue in the SGA. Put the above task in the order in which they are performed.（）A 3，1，6，2，5，4B 3，6，1，5，2，4C 3，1，2，3，4，5D 6，1，3，5，2，4E 6，3，1，2，4，5F 6，3，1，2，5，4” 相关考题
考题
Which statements are true regarding table compression? ()(Choose all that apply.)
A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs extra CPU overhead during DML but not direct loading operations.E. It requires uncompress operation during I/O.
考题
Which correctly describes the tiers of the Oracle Workflow architecture?()
A. Oracle Database tier and Application server tier onlyB. Oracle Database tier, Application server tier, and End-user client tier onlyC. Oracle Database tier, Application server tier, and Development client tier onlyD. Oracle Database tier, Application server tier, Development client tier, and End-user client tier
考题
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 upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（） A、 MMANB、 PMONC、 MMOND、 MMNL
考题
You are configuring for Oracle Shared Server. Which service is required？ （）A、Oracle Net ServiceB、Oracle HTTP ServiceC、Oracle Paging ServiceD、Internet Directory Service
考题
The multithreaded agent architecture for heterogeneous services is similar to the Oracle multithreaded server architecture. The principal difference is that it used threads instead of processes. What are thee kinds of threads that it uses？（）A、TCPB、TaskC、MonitorD、DispatcherE、Shared ServerF、Shutdown address
考题
Identify the memory component from which memory may be allocated for: （） 1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operations A、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area （PGA）
考题
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（） A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository
考题
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.
考题
Which statements are true regarding table compression？（）A、 It saves disk space and reduces memory usage.B、 It saves disk space but has no effect on memory usage.C、 It incurs extra CPU overhead during DML as well as direct loading operations.D、 It incurs extra CPU overhead during DML but not direct loading operations.E、 It requires uncompress operation during I/O.
考题
For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
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.
考题
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
Under the Oracle Shared Server architecture， client-user processes ultimately connect to a（）A、serviceB、listenerC、dispatcherD、shared server process
考题
Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area （PGA）
考题
单选题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.
考题
单选题The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process， the following tasks are performed： 1.A shared server picks up the request from the request queue and processes the request. 2.The dispatcher retrieves the response from the response queue. 3.A user sends a request to its dispatcher. 4.The dispatcher returns the response to the user. 5.The shared sever places the response on the calling dispatcher’s response queue. 6.The dispatcher places the request into the request queue in the SGA. Put the above task in the order in which they are performed.（）A
3，1，6，2，5，4B
3，6，1，5，2，4C
3，1，2，3，4，5D
6，1，3，5，2，4E
6，3，1，2，4，5F
6，3，1，2，5，4
考题
单选题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
考题
单选题Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA
Large PoolB
Redo Log BufferC
Database Buffer CacheD
Program Global Area （PGA）
考题
多选题You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（）AAdvisor CentralBGlobal AttributesCResource MonitorsDMemory ParametersEDatabase Usage StatisticsFAll Initialization ParametersGAutomatic Workload Repository
考题
单选题You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（）A
MMANB
PMONC
MMOND
MMNL
考题
单选题Identify the memory component from which memory may be allocated for: （） 1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operationsA
Large PoolB
Redo Log BufferC
Database Buffer CacheD
Program Global Area （PGA）
考题
单选题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.
考题
多选题Which statements are true regarding table compression？（）AIt saves disk space and reduces memory usage.BIt saves disk space but has no effect on memory usage.CIt incurs extra CPU overhead during DML as well as direct loading operations.DIt incurs extra CPU overhead during DML but not direct loading operations.EIt requires uncompress operation during I/O.
考题
单选题Under the Oracle Shared Server architecture， client-user processes ultimately connect to a（）A
serviceB
listenerC
dispatcherD
shared server process
考题
单选题For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
考题
单选题Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
考题
多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables
热门标签
最新试卷
