Oraclecom and the sidname is tst8 how should you

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: NECTION parameter in Oracle. Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1013-1017 Chapter 21: Overview of Net8 for Client and Server QUESTION 85: You are using the host naming method assuming the GLOBAL_DBNAME is wwwed-sun.us.oracle.com and the SID_NAME is TST8. How should you specify the connection request? A. Connect username/password. B. Connect username/password@tst8 C. Connect username/password@global_dbname D. Connect username/password@wwwed1-sun.us.oracle.com Answer: D Explanation: Answer D is correct. You need to use full database name, including domain, if GLOBAL_DBNAME is wwwed-sun.us.oracle.com. GLOBAL_DBNAME is parameter in the listener.ora file, it identifies the global database name of the database, a name comprised of the database name and database domain. You can obtain the GLOBAL_DBNAME value from the SERVICE_NAMES parameter in the initialization parameter file. Incorrect Answers: A is incorrect; there is no information in the question that LOCAL variable is set, so this syntax is incorrect. B is incorrect; since GLOBAL_NAME is specified, it will be used as connect descriptor for user connection. C is incorrect; there is no "global_dbname" connect descriptor, so this connection will be refused. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 986-987 Chapter 21: Overview of Net8 for Client and Server QUESTION 86: Which two methods can the DBA use to decrease the number of dispatchers? (Choose two) Actualtests.com - The Power of Knowing 1Z0-026 A. Restart the listener. B. Issue the ALTER SYSTEM command. C. Issue the ALTER SESSION command. D. Edit the MTS_DISPATCHERS parameter and bounce the database. E. Edit the MTS_MAX_DISPATCHERS parameter and bounce the database. Answer: B, D Explanation: Answers B and D are correct. To decrease number of dispatchers DBA can issue the ALTER SYSTEM command or edit the MTS_DISPATCHERS parameter and bounce the database. Incorrect Answers: A is incorrect; it is not possible to decrease the number of dispatchers by restarting the listener. C is incorrect; you cannot decrease the number of dispatchers with the ALTER SESSION command. E is incorrect; parameter MTS_MAX_DISPATCHERS is set to a number represents the maximum number of dispatcher processes for all network protocols combined that can be started for the duration of an instance. It cannot be used to decrease the number of dispatchers running currently. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1061-1064 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 87: Which is the benefit of the Oracle Advanced Security option? A. Enables break-in detection. B. Enables high network availability. C. Enables encrypted transmission of data. D. Enforces password lifetime restrictions. Answer: C Explanation: Answer C is correct. The Oracle Advanced Security option enables encrypted transmission of data, data integrity, authentication and authorization. Incorrect Answers: A is incorrect; the Oracle ASO does not enable break-in detection. B is incorrect; it does not provide high network availability. D is incorrect; password lifetime restriction is not a feature of the Oracle Advanced Security option. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1114-1115 Chapter 23: Connection Manager, Troubleshooting, and Security Actualtests.com - The Power of Knowing 1Z0-026 QUESTION 88: 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 Oracle instance running on a remote UNIX server. However, there are no problems when using FTP between the two nodes. What action next taken by the DBA could make progress toward diagnosing the problem? A. Checking to see if the domain name server (DNS) configuration is correct. B. Checking to see if the tnsping process is running on the server. C. Checking to see if the listener process is running on the client. D. Checking to see of a local connection can be made to the database. Answer: D Explanation: Answer D is correct. The DBA needs to check a local connection to the database first. Incorrect Answers: A is incorrect; since there is no problem using FTP, the DBA does not need to check DNS configuration. B is incorrect; the tnsping is a utility, it does not need to run on the server. The DBA can use it to check access to the database from the client. C is incorrect; the listener process runs on the server, not on the client. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 986-987 Chapter 21: Overview of Net8 for Client and Server QUESTION 89: Which statement regarding network security is false? A. Data privacy ensures that data is not disclosed or stolen during transmission. B. Authorization permits a user to access the Internet through the company firewall. C. Data integrity ensures that data is not modified or disrupted during transmission. D. Authentication ensures that the identities of users, hosts, and clients are correctly known. Answer: B Explanation:...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online