i think A, C and F
D is wrong
Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168
An ***idle shared server process picks up*** the virtual circuit from the common queue
see https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-processes.html#GUID-A522BFBF-5452-4038-92DB-C5116A0B1B50
A - TRUE; All dispatchers are required to write incoming requests to a common response queue, which the (idle) shared server processes will monitor and pick up.
B - FALSE; Each dispatcher has its own response queue.
C - TRUE; This is the main purpose of dispatchers in a shared server architecture.
D - FALSE; Connection input requests are handled by the listener and, shared server processes do not have their own input queues, they monitor the common input queue.
E - FALSE; Shared server responses cannot be broadcasted to all connections.
F - TRUE; Shared server responses must be sent back to the requester on its own connection.
C,D,F
In a shared server configuration, dispatchers are responsible for managing incoming requests and outgoing responses. When a user connects to the database using a shared server configuration, the dispatcher receives the user's request and places it in the common request queue. The dispatcher then selects an available shared server and assigns the request to it by placing it in the appropriate shared server input queue.
The shared server then processes the request and generates a response, which is placed in the appropriate outbound response queue. The dispatcher checks for outbound shared server responses on the common outbound response queue and sends the response back to the requester on the appropriate connection.
A is correct. All dispatchers are required to write incoming requests to a common response queue, which the (idle) shared server processes will monitor and pick up.
B is wrong. Each dispatcher has it's own response queue.
C is correct. This is the main purpose of dispatchers in a shared server architecture.
D is wrong. Connection input requests are handled by the listener and, shared server processes do not have their own input queues, they monitor the common input queue.
E is wrong. Shared server responses cannot be broadcasted to all connections.
F is correct. Shared server responses must be sent back to the requester on it's own connection.
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/application-and-networking-architecture.html#GUID-EC8F8778-02B7-4CF9-9E6F-A5D88C777235
I think C, D, F, only because of the wording. "A" states " common request queue FROM all shared server connections". The dispatches send requests TO shared server connections. The send responses FROM the shared server connections.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Abhirup
Highly Voted 3 years, 5 months agoNiciMilo
Highly Voted 3 years, 5 months agonautil2
Most Recent 4 months agoGuhborges
9 months, 4 weeks agoFranky_T
1 year, 9 months agoAramazd
1 year, 9 months agoAramazd
1 year, 9 months agoAramazd
1 year, 9 months agoAramazd
1 year, 9 months agobrolem
2 years, 5 months ago