E is incorrect service names are not loaded

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: and RELOAD in the NAMECTL. Incorrect Answers: A is incorrect; there is no S service name in the Net8 Assistant by default. B is incorrect; you cannot load service names from an existing sqlnet.ora file. This file is used to configure the client settings. E is incorrect; service names are not loaded dynamically when the Names Server is restarted. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1054-1055 Chapter 23: Connection Manager, Troubleshooting, and Security QUESTION 100: Which file stores the profile information using the Net8 Assistant tool? (Do not use any extra words or characters) Answer: TNSNAMES.ORA Explanation: Tnsnames.ora file stores the profile information using the Net8 Assistant tool. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1011-1017 Chapter 21: Overview of Net8 for Client and Server QUESTION 101: Which two statements describe the MTS_MAX_SERVERS initialization parameter? (Choose two) A. MTS_MAX_SERVERS can be altered dynamically. B. MTS_MAX_SERVERS specifies the number of shared server processes initially started. C. MTS_MAX_SERVERS specifies the number of shared server processes that can run simultaneously. D. Shared server processes should be monitored to determine an ideal setting for MTS_MAX_SERVERS parameter. Actualtests.com - The Power of Knowing 1Z0-026 Answer: C, D Explanation: Answers C and D are correct. MTS_MAX_SERVERS specifies the number of shared server processes that can run simultaneously. The DBA needs to monitor shared server processes to determine an ideal setting for MTS_MAX_SERVERS parameter. It is wise to specify a smaller number of shared-server processes. This is because Oracle will automatically start servers during periods of high load volume, up to a maximum number of shared servers set by this parameter. When the load decreases, Oracle will kill the shared servers it started if they sit idle for too long, as well. However, Oracle never kill the shared servers started at instance startup as specified by the MTS_SERVERS parameter. Incorrect Answers: A is incorrect; MTS_MAX_SERVERS cannot be altered dynamically. B is incorrect; MTS_SERVERS, not MTS_MAX_SERVERS, parameter specifies the number of shared server processes initially started. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1065-1066 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 102: What are 'well-known Names Servers'? A. Names servers that are listed in the clients sqlnet.ora file. B. Names servers that are listed in the clients tnsnames.ora file. C. Names servers that automatically registered to listeners in the network. D. Addresses for one or more Names Servers hard-coded into the Oracle Names server and its client. Answer: D Explanation: Answer D is correct. 'well-known Names Servers' are addresses for one or more Names Servers hard-coded into the Oracle Names server and its client. Incorrect Answers: A is incorrect; Names servers are not listed in the clients sqlnet.ora file. B is incorrect; Names servers are not listed in the clients tnsnames.ora file. D is incorrect; Names servers are never automatically registered to listeners in the network. network. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1036-1037 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 103: Which two parameters can be specified for client load balancing? (Choose two) Actualtests.com - The Power of Knowing 1Z0-026 A. FAILOVER B. LOAD_BALANCE C. LOAD_BALANCING D. ENABLE_FAILOVER E. ENABLE_LOAD_BALANCE Answer: A, B Explanation: Answers A and B are correct. FAILOVER and LOAD_BALANCE parameters can be specified for client load balancing. Incorrect Answers: C is incorrect; there is no LOAD_BALANCING parameter can be specified for client load balancing. D is incorrect; there is no ENABLE_FAILOVER parameter in Oracle. E is incorrect; there is no ENABLE_LOAD_BALANCE parameter in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1086-1091 Chapter 23: Connection Manager, Troubleshooting, and Security QUESTION 104: You are configuring local naming using Net8 assistant and want the tnsnames.ora file read for resolution before the host file is read. Which file can you manually edit to change the ordering of the method of resolution? A. Sqlnet.ora B. Tnsnames.ora C. Names.ora D. Init.ora E. Config.ora F. Listener.ora Answer: A Explanation: Answer A is correct. Sqlnet.ora file needs to be edited to change the order of the method of resolution and to identify other client preferences, like tracing, logging, routing and so on. Incorrect Answers: B is incorrect; tnsnames.ora file is used to store service names created by Net8 Assistant. C is incorrect; names.ora file is responsible for the Oracle Names Servers configuration. D is incorrect; init.ora file is used to startup an Oracle instance and open the database. E is incorrect; there is no config.ora file in Oracle. F is incorrect; listener.ora file is used to set Oracle listener process settings. Orac...
View Full Document

Ask a homework question - tutors are online