46.
Dispatchers have all the following characteristics except:
- A.Dispatchers can be shared by many connections.
- B.More dispatchers can be added dynamically with the ALTER SYSTEM command.
- C.A dispatcher can listen for multiple protocols.
- D.Each dispatcher has its own response queue.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Many users can connect to dispatchers, and dispatchers can be added dynamically. Also, each dispatcher does have its own response queue. The only one of these options that is false is option C because dispatchers can listen for only one protocol. You can configure multiple dispatchers so that each is responsible for different protocols. |
47.
When configured in Shared Server mode, which of the following is contained in the PGA?
- A.Cursor state
- B.Sort information
- C.User session data
- D.Stack space
- E.None of the above
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| A small PGA is maintained even though most of the user-specific information is moved to the SGA (specifically called the UGA in the Shared Pool or the Large Pool). The only information left in the reduced PGA is stack space. |
48.
Which of the following is false about shared servers?
- A.Shared servers can process requests from many users.
- B.Shared servers receive their requests directly from dispatchers.
- C.Shared servers place completed requests on a dispatcher response queue.
- D.The SHARED_SERVERS parameter configures the number of shared servers to start at instance startup.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Shared Servers can process requests from many users. The completed requests are placed into the dispatchers' response queues. The servers are configured with the SERVERS parameter. However, shared servers do not receive requests directly from dispatchers. The requests are taken from the request queue. |
49.
Which of the following is not a step in the processing of a Shared Server request?
- A.Shared servers pass information back to the client process.
- B.Dispatchers place information in a request queue.
- C.Users pass requests to a dispatcher.
- D.The dispatcher picks up completed requests from its response queue.
- E.None of the above.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| Study the steps of what happens during a request via Shared Server. Dispatchers receive requests from users and place the requests on request queues. Only dispatchers interact with client processes. Shared servers merely execute the requests and place the results back on the dispatcher's response queue. |
50.
When you are configuring Shared Server, which initialization parameter would you likely need
to modify?
- A.DB_CACHE_SIZE
- B.DB_BLOCK_BUFFERS
- C.LARGE_POOL_SIZE
- D.BUFFER_SIZE
- E.None of the above
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Shared Server requires a shift of memory away from individual session processes to the SGA. More information has to be kept in the SGA (in the UGA) within the Shared Pool. A Large Pool is configured and is responsible for most of the SGA space allocation. Option C is the correct answer. The cache size and block buffers settings do not affect Shared Server. |
|
|
||||||||||||||||||||||||||||
