Oracle 8 dba certification exam guide jason s

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: se third party resolution mechanisms. D is incorrect; an advantage of Centralized Naming is decrease administrative tasks. No additional administration time and resources are needed to support Centralized Naming, less resources and support time is needed. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1036-1049 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 66: Which three types of data are stored by Oracle names? (Choose three) A. List of available protocols. B. List of global database links. C. Names and addresses of Names Server. D. List of registered dispatcher and addresses. E. Names and listener addresses of all Connection Managers on the network. Answer: B, C, E Explanation: Answers B, C and E are correct. Oracle Names server stores list of global database links, names and addresses of Names Server. Also it stores names and listener addresses of all Actualtests.com - The Power of Knowing 1Z0-026 Connection Managers on the network. Incorrect Answers: A is incorrect; it does not store list of available protocols. D is incorrect; list of registered dispatcher and addresses is not stored by Oracle names. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1036-1049 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 67: When configuring the tnsnames.ora file for connection concentration which address is listed first in the description of the service net name? A. Address for the CMGW process. B. Address for the CMADM process. C. Address for the database listener. D. Address for the database dispatcher. Answer: A Explanation: Answer A is correct. An address for the Connection Manger Gateway (CMGW) is listed first in the description of the service net name inside the tnsnames.ora file. Incorrect Answers: B is incorrect; not an address of Connection Manager Administrator (GMADM), but an address for the Connection Manger Gateway (CMGW) is listed first. C is incorrect; not an address of the database listener, but an address for the Connection Manger Gateway (CMGW) is listed first. D is incorrect; not an address of the database dispatcher, but an address for the Connection Manger Gateway (CMGW) is listed first. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1082-1088 Chapter 23: Connection Manager, Troubleshooting, and Security QUESTION 68: What does the namesini.SQL script do? A. Setup a Names Server. B. Creates a region database. C. Creates a user within a region database. D. Creates tables within a schema of region database. Answer: D Explanation: Answer D is correct. Namesini.sql script creates tables within a schema of region database. Actualtests.com - The Power of Knowing 1Z0-026 Incorrect Answers: A is incorrect; this script does not setup a Names Server. B is incorrect; it does not create a region database. C is incorrect; namesini.ora script is not used to create a user within a region database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1047-1048 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 69: Which environment variable is used to help setup Oracle names? A. ADMIN_TNS B. TNS_NAMES C. TNS_ADMIN D. NAMES_TNS E. NAMES_ADMIN F. ADMIN_NAMES Answer: C Explanation: Answer C is correct. TNS_ADMIN environment variable is used to help setup Oracle names. You can add the TNS_ADMIN parameter to change the directory name for configuration files from the default location. For example, if you set TNS_ADMIN to ORACLE_HOME\TEST\ADMIN, the configuration files are used from ORACLE_HOME\TEST\ADMIN. Incorrect Answers: A is incorrect; there is no ADMIN_TNS environment variable in Oracle. B is incorrect; there is no ADMIN_TNS environment variable in Oracle. D is incorrect; there is no NAMES_TNS environment variable in Oracle. E is incorrect; there is no NAMES_ADMIN environment variable in Oracle. F is incorrect; there is no ADMIN_NAMES environment variable in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1036-1046 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 70: A DBA has installed and configured Net8 for TCP/IP on the client and server. But is still unable to connect from a Windows NT Workstation using SQL*Plus to an instance running on a remote UNIX server. However there are no problems when using FTP nodes. What action next taken by the DBA could make progress towards diagnosing the problem? A. Using the NETSTAT command on the server. B. Attempting to ping the domain name server from the client. C. Connecting by using the Net8 Assistant Test Connection feature. Actualtests.com - The Power of Knowing 1Z0-026 D. Checking the settings in the Oracle instance parameter file (init<SID>.ora file). Answer: C Explanation: Answer C is correct. To diagnose the problem the DBA should connect by using the Net8 Assistant Test Connection feature. Incorrect Answers: A is incorrect; there is no NETSTAT commanding Oracle. B is incorrect; since FTP works fine you don't need to test host accessibility by pinging the domain name serv...
View Full Document

Ask a homework question - tutors are online