READ Free Dumps For Oracle- 1z0-026
| Question ID 21377 | Which naming method simplifies administrative tasks when configuration changes need to be made available to
all clients immediately?
|
| Option A | Host Naming
|
| Option B | Local Naming
|
| Option C | Service Naming
|
| Option D | Centralized Naming
|
| Correct Answer | D |
Explanation Explanation: Answer D is correct. When configuration changes need to be made available to all clients immediately, centralized naming method simplifies administrative tasks. Incorrect Answers: A is incorrect; host naming is used for small database environments, where there are not a lot of users. B is incorrect; local naming cannot be used for this purpose, because it will be required to change every tnsnames.ora file for each client if configuration will be changed. C is incorrect; there is no service naming connection method in Oracle.
| Question ID 21378 | Which process picks up a request from a response queue?
|
| Option A | Client process
|
| Option B | Listener process
|
| Option C | Dispatcher process
|
| Option D | Shared server process
|
| Correct Answer | C |
Explanation Explanation: Answer C is correct. When MTS is being used, the listener passes the user process to another process called a dispatcher. The user process will be handed off by the listener to the least busy dispatcher process. The dispatcher process maintains two queues, called a request queue and a response queue. The longer the request queue is at any given time, the more work a dispatcher has to accomplish on behalf of the user process assigned it. Dispatcher processes work with shared-server processes to accomplish the work that is in the request queue. A shared server will grab the request at the beginning of the queue and process the work requested. When the shared server is finished, it puts the information obtained from the Oracle database onto the response queue, where the user process that made the request can pick up the results. Incorrect Answers: A is incorrect; dispatcher process picks up a request from a response queue on behalf of client process. B is incorrect; listener process is used to provide connection for user process to the database, it does not work with a response queue. D is incorrect; shared server process puts the information onto the response queue, it picks up an initial request from a request queue.