To turn on connection pooling set the pool option to

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: . Tnsnames.ora D. Listener.ora Answer: A Explanation: Answer A is correct. Connection pooling is configured using the MTS_DISPATCHERS initsid.ora parameter. To configure connection pooling on a particular dispatcher, you must use the POOL option in the following way. To turn on connection pooling, set the POOL option to ON, YES, TRUE, or BOTH. You can also define connection pooling in either the direction of client to server or vice-versa by setting POOL to IN or OUT, respectively. Incorrect Answers: B is incorrect; you don't need to edit sqlnet.ora file to enable connection pooling. C is incorrect; you don't need to edit tnsnames.ora file to enable connection pooling. D is incorrect; you don't need to edit listener.ora file to enable connection pooling. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1067-1068 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 52: What are two characteristics of the local naming method? (Choose two) A. It resolves service names across different protocols. Actualtests.com - The Power of Knowing 1Z0-026 B. You must have TCP/IP installed on your server machine. C. You must include the GB_DBNAME parameter in the listener.ora file. D. It provides a straightforward method for resolving service name addresses. E. It eliminates the need to create and maintain a local names configuration file. Answer: A, D Explanation: Answers A and D are correct. The local naming method resolves service names across different protocols (the host naming method works only with TCP/IP protocol, for example) and it provides a straightforward method for resolving service name addresses. Incorrect Answers: B is incorrect; this method does not require TCP/IP installed on your server (or client) machine because it resolves service names across different protocols. C is incorrect; there is no GB_DBNAME parameter in the listener.ora file. E is incorrect; only host naming and Names server methods eliminate the need to create and maintain a local names configuration file: tnsnames.ora. Local hosting method requires this file presence on every client machine. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1011-1017 Chapter 21: Overview of Net8 for Client and Server QUESTION 53: Your Net8 environment includes many Names servers and you want to store thus information in a repository. What can you create? A. Client database. B. Region database. C. Network database. D. Host database. Answer: B Explanation: Answer B is correct. Region database works as repository for the many Names servers. Incorrect Answers: A is incorrect; there is no client database in the Names server configuration. C is incorrect; there is no network database in the Names server configuration. D is incorrect; there is no host database in the Names server configuration. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1047-1049 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 54: Which statement regarding the logging and tracing of Net8 is False? Actualtests.com - The Power of Knowing 1Z0-026 A. The trace_level_client parameter may be set to ADMIN level. B. The trace_file_client parameter controls the name of the trace file. C. TNSPING does not need to be run for the Net8 tracing facility to be activated. D. The trace_unique_client parameter controls the number of clients that can be traced simultaneously at any given time. Answer: D Explanation: Answer D is correct. The trace_unique_client parameter used to make each client trace file have a unique name to prevent each trace file from being overwritten with the next occurrence of the client. The PID is attached to the end of the filename. Incorrect Answers: A is incorrect; the trace_level_client parameter can be set to OFF/USER/ADMIN level. B is incorrect; the trace_file_client parameter shows the name of the trace file. C is incorrect; you don't need to run TNSPING for the Net8 tracing facility to be activated. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1097-1104 Chapter 23: Connection Manager, Troubleshooting, and Security QUESTION 55: Which statement regarding network security is False? A. Data encryption ensures that data is not encrypted during transmission. B. Data integrity ensures that data is not disclosed or stolen during transmission. C. Authentication ensures that the identities of the users, hosts and clients are correctly known. D. Authorization permits a user a program or a process to access an object or set of objects as desired by the administrator. Answer: C Explanation: Answer C is correct. Authentication ensures that the identities of the users, not host and clients, are correctly known. Incorrect Answers: A is incorrect; data encryption ensures that data is not encrypted during transmission. This feature is supported by Advanced Networking Option (ANO). B is incorrect; data integrity ensures that data is not disclosed or stolen during transmission. D is incorrect; authorization permits a user a program or a process to access an object or set of objects as desired by the administrator. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1114-1115 Chapter 23: Connection Manager, Troubleshooting, and Sec...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online