A tracing is always enabled for net8 connections b

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: can be used for local naming access if Names servers are down. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1036-1043 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 31: Which statement about Net8 tracing is true? A. Tracing is always enabled for Net8 connections. B. Tracing files can only be created on the database server. C. Trace files contain less detailed information than log file. Actualtests.com - The Power of Knowing 1Z0-026 D. Because tracing caused overhead for every session, it should not used only when necessary to resolve an error. Answer: D Explanation: Answer D is correct. You should enable tracing only for the duration of a process 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 32: How can the DBA dynamically change the listener password? A. By editing the listener.ora file. B. By issuing the SET PASSWORD command. C. By issuing the CHANGE_PASSWORD command. D. By launching the ORAPWD password utility. Answer: C Explanation: Answer C is correct. The CHANGE_PASSWORD command of LSNRCTL utility can be used to change the listener password. Incorrect Answers: A is incorrect; the password is not stored in the listener.ora file, there are only listener settings in the listener.ora file. B is incorrect; there is no SET PASSWORD command in the LSNRCTL utility. D is incorrect; the ORAPWD password utility is used to reset password to authenticate INTERNAL/SYS user in the password file. It will not reset the listener password. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1001-1003 Chapter 21: Overview of Net8 for Client and Server QUESTION 33: In which situation would you use the namesini.sq1 script? A. When setting up a Names user. B. When setting up a region database. Actualtests.com - The Power of Knowing 1Z0-026 C. When resetting the Names database. D. When setting up the first Names server of a region Answer: D Explanation: Answer D is correct. To set up the first Names server of a region you need to use the namesini.sql script. Incorrect Answers: A is incorrect; there is no a Names user in Oracle. All users can connect to Names server. B is incorrect; you don't need to use the namesini.sql script when setting up a region database. C is incorrect; you don't need to use the namesini.sql script when resetting the Names database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1047-1048 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 34: Which parameter would you set to enable connect-time failover for multiple listeners? (Do not use any extra words or characters) Answer: SHUTDOWN TRANSACTION Explanation: Option "connect_timeout seconds" specifies seconds to be the amount of time that the listener will wait for connection request after the connection is started. To enable this connect-time failover feature for multiple listeners you need to use command SHUTDOWN with TRANSACTIONAL parameter. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1003-1004 Chapter 21: Overview of Net8 for Client and Server QUESTION 35: What do you need to do to make Centralized Naming available? A. Startup the Names Server. B. Create and configure the Names Server. C. Startup the database names listener. Startup the database you are trying to reach. D. Add the region database to the tnsnames.ora file. Answer: A Explanation: Answer A is correct. To enable Centralized Naming you need to start the Names Server. Incorrect Answers: Actualtests.com - The Power of Knowing 1Z0-026 B is incorrect; creation and configuration of the Names Server without starting it will not make Centralized Naming available. C is incorrect; without creation, configuration and starting of the Names Server Centralized Naming will not be available for usage. D is incorrect; this will not enable Centralized Naming feature either. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1036-1043 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 36: How can the DBA determine the location of the listener log file? A. View the init.ora file. B. Issue the SHOW LISTENER command. C. Issue the SHOW LOG_DIRECTORY command. D. Query the dynamic performance view V$LISTENER. Answer: C Explanation: Answer C is correct. To see the location of the listener log file you can issue the SHOW LOG_DIRECTORY command. Incorrect Answers: A is incorrect; the init.ora file does not provide this information. B is incorrect; there is no SHOW LISTENER command in Oracle. D is incorrect; there is n...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online