Couchman p 1011 1016 chapter 21 overview of net8 for

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: er from the client. D is incorrect; the DBA should test connection with Test Connection feature. Init<SID>.ora file have nothing to do with connectivity problem from client. It used only to start the database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1011-1016 Chapter 21: Overview of Net8 for Client and Server QUESTION 71: When configuring Connection Manager for connection concentration which file will contain the attribute MULTIPLEX or MUL? A. Init.ora B. Cman.ora C. Sqlnet.ora D. Tnsnames.ora Answer: A Explanation: Answer A is correct. Init.ora file contain the attribute MULTIPLEX or MUL of MTS_DISPATCHERS parameter to configure Connection Manager for connection concentration. Incorrect Answers: B is incorrect; cman.ora file does not contain these attributes. C is incorrect; sqlnet.ora file does not contain these attributes. D is incorrect; tnsnames.ora file does not contain these attributes. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1086-1088 Chapter 23: Connection Manager, Troubleshooting, and Security QUESTION 72: What does a shared server process do? A. Processes user requests. B. Processes connection request. Actualtests.com - The Power of Knowing 1Z0-026 C. Passes on request to a listener. D. Passes on request to an available dispatcher. Answer: A Explanation: Answer A is correct. Shared servers grab requests from the request queue where dispatcher put it, process the work requested and returns results onto the response queue, where dispatcher can pick up the results to pass them to the user. Incorrect Answers: B is incorrect; listener process, not shared server, works with connection requests. C is incorrect; it does not pass any request to a listener. D is incorrect; it returns results onto the response queue, where dispatcher can pick up the results to pass them to the user. A shared server does not pass any requests directly to an available dispatcher. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1061-1063 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 73: In a multithreaded environment which two criteria have to be met for a listener to give a client the address of a dispatcher? (Choose two) A. A client must not request a dedicated server. B. The client must match the dispatcher's protocol type. C. There must be an idle dispatcher available for the client. D. The client must run the same Net8 version as the dispatcher. E. There must be idle shared server available for the client. Answer: A, C Explanation: Answers A and C are correct. In a multithreaded environment a client must not request a dedicated server. Also there must be an idle dispatcher available for a listener to give a client the address of a dispatcher. Dispatcher does not need to be idle to process user's request. Oracle will choose dispatcher with lowest level of loading to process new connection. You need to be sure that you configured enough dispatchers to handle the number of concurrent users connected to your Oracle database. Configuration option CONNECTION defines the maximum number of network connections to allow for each dispatcher. Incorrect Answers: B is incorrect; the client must not match the dispatcher protocol type. D is incorrect; there is no restriction that the client must run the same Net8 version as the dispatcher. E is incorrect; there must not be idle shared server available for the client. Oracle will automatically start more shared servers during periods of high load volume, up to a Actualtests.com - The Power of Knowing 1Z0-026 maximum number of shared servers set by the initsid.ora parameter MTS_MAX_SERVERS. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1061-1068 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 74: When is the bequeath session used by default? A. In a dedicated server environment with prespawned server processes. B. In a multithreaded server environment with shared server processes. C. When there are no prespawned server processes in a dedicated server environment. Answer: C Explanation: Answer C is correct. The bequeath session will be used by default when there are no prespawned server processes in a dedicated server environment. Incorrect Answers: A is incorrect; it will be used when there are no prespawned server processes in a dedicated server environment, not with prespawned server processes. B is incorrect; it is used in dedicated server environment, not in multithreaded server environment. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1061-1063 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 75: Which names directory object is a group of Net8 network clients and servers using the same industry-standard protocol? A. Community B. Data Repository C. Administrative region D. Multiprotocol Interchange Answer: A Explanation: Answer A is correct. Community is a group of Net8 network client and servers using the same industry-standard protocol. Incorrect Answers: B is incorrect; database repository...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online