A connection request times b client program software

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: also. It is just feature of MTS configuration. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1083-1086 Chapter 23: Connection Manager, Troubleshooting, and Security QUESTION 80: What information is never provided in the listener audit trail? A. Connection request times. B. Client program (software) information. C. Domain Names Server (DNS) information. D. LSNRCTL utility commands issued. Answer: B Explanation: Answer B is correct. The listener audit trial does not provide client program information. Incorrect Answers: A is incorrect; it shows connection request times. B is incorrect; the listener audit trial provides Domain Names Server (DNS) information. D is incorrect; it can also show LSNRCTL utility commands issued. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1093-1101 Chapter 23: Connection Manager, Troubleshooting, and Security Actualtests.com - The Power of Knowing 1Z0-026 QUESTION 81: Which Net8 component waits for incoming requests on the server side? A. PortB. Server C. Listener D. Dispatcher E. Background process Answer: C Explanation: Answer C is correct. Listener waits for incoming requests on the server side. Client requests connection, Net8 then travels the network, looking for the host machine named in the descriptor. Once found on that machine using the specific port identified in the connect descriptor. A listener process should be running on the server, tuned into that particular port, waiting for user process to call. The listener process knows what port to listen to because that port is identified in the connect descriptor. When the listener hears the incoming connection, the listener will either refuse the connection or allow the connection. A listener will refuse a connection if the user process requests a connection to an Oracle database that this listener does not listen for, if user authentication information provided isn't valid, or if the Oracle database is not available. Incorrect Answers: A is incorrect; the listener waits for incoming requests, it listens on specific port. B is incorrect; the listener, not server, helps to connect client to the database. D is incorrect; the dispatcher receives user connections after listener passed it to the dispatcher. E is incorrect; background process does not work with incoming request directly, it process user requests via listener. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 986-987 Chapter 21: Overview of Net8 for Client and Server QUESTION 82: Which statement about Net8 tracing is true? A. Tracing is always enabled for Net8 connections. B. Trace files can only be created on a database server. C. Trace files contain less detailed information than log files. D. Tracing should be used only when logging does not give sufficient information to resolve a network error. Answer: D Explanation: Answer D is correct. You should enable tracing only for the duration of a process Actualtests.com - The Power of Knowing 1Z0-026 producing an error you are trying to resolve. Otherwise, it can cause huge overhead on database and decrease system performance. Incorrect Answers: A is incorrect; tracing is not always enabled for Net8 connections. B is incorrect; tracing files can be also created on the client side. C is incorrect; trace files contain more detailed information than log file, so tracing needs to be used when additional information for analyze required. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1093-1101 Chapter 23: Connection Manager, Troubleshooting, and Security QUESTION 83: Your system has 900 concurrent users. They connect using TCP/IP and 255 connections per process are supported. How many dispatcher processes should the DBA initially specify? A. 3 B. 4 C. 10 D. The default value. Answer: B Explanation: Answer B is correct. The DBA should initially specify 4 dispatcher processes. For each dispatcher it will be 225 connections, it is less than maximum allowed number of connections per process. Incorrect Answers: A is incorrect; there is not enough dispatchers, because each of it needs to process 300 connections. C is incorrect; this number is too much, we just will waste our resources. D is incorrect; DBA can not rely on default value of initial number of dispatchers. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1061-1068 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 84: Which parameter can you set, to enable the dead connection detection feature? A. SQLNET.EXPIRE_TIME B. TNSNAMES.EXPIRE_TIME C. SQLNET.MONITOR_CONNECTION D. TNSNAMES.MONITOR_CONNECTION Answer: A Actualtests.com - The Power of Knowing 1Z0-026 Explanation: Answer A is correct. SQLNET.EXPIRE_TIME parameter of sqlnet.ora file enables the dead connection detection feature. Incorrect Answers: B is incorrect; there is no TNSNAMES.EXPIRE_TIME parameter in Oracle. C is incorrect; there is no SQLNET.MONITOR_CONNECTION parameter in Oracle. D is incorrect; there is no TNSNAMES.MONITOR_CON...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online