READ Free Dumps For Oracle- 1z0-026
| Question ID 21360 | When is the request sent to a listener?
|
| Option A | After every call.
|
| Option B | Before every call.
|
| Option C | After name resolution.
|
| Option D | Before name resolution.
|
| Correct Answer | C |
Explanation Explanation: Answer C is correct. In order for Net8 to recognize the connect string you provide as a valid representation for a database somewhere on the network, your connect string must map to a connect descriptor, which is a description of the Oracle service you want to connect to. Net8 then travels the network, looking for the host machine named in the descriptor. Once found, Net8 calls on that machine using the specific port identified in the connect descriptor. A listener process should be running on the server, turned into that particular port, waiting for user processes to call. Incorrect Answers: A: is incorrect; you don't need to send request to a listener after every call, it needs to be done only after name resolution. B is incorrect; you don't need to send request to a listener before every call, it needs to be done only after name resolution. D is incorrect; Net8 need first perform name resolution using connect descriptor sent it by client and only after that sent request to a listener for connection.
| Question ID 21361 | The initial number of dispatchers is set to 50. Because of the load on the dispatcher processes the DBA needs
to decrease the number of dispatchers. Which two recommended procedures could be used? (Choose two)
|
| Option A | Issue the ALTER SYSTEM command to remove dispatchers.
|
| Option B | Issue the ALTER SESSION command to remove dispatchers.
|
| Option C | Edit the MTS_DISPATCHERS parameter and bounce the database.
|
| Option D | Edit the MTS_MAX_DISPATCHERS parameter and bounce the database.
|
| Option E | Edit the MTS_MIN_DISPATCHERS parameter and bounce the database.
|
| Correct Answer | A,C |
Explanation Explanation: Answers A and C are correct. To decrease number of dispatchers used in MTS configuration, you need to configure MTS_DISPATCHERS parameter in you init.ora file and then restart the instance. You can also use the name=value syntax at the SQL prompt to dynamically change the number of dispatchers on your system, or to accomplish other reconfiguration tasks. Incorrect Answers: B is incorrect; you cannot decrease the number of dispatchers with the ALTER SESSION command. D is incorrect; parameter MTS_MAX_DISPATCHERS is set to a number represents the maximum number of dispatcher processes for all network protocols combined that can be started for the duration of an instance. It cannot be used to decrease the number of dispatchers running currently. E is incorrect; there is no MTS_MIN_DISPATCHERS parameter in Oracle.