A shut down the instance b disconnect all database

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: o the dynamic performance view V$LISTENER in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1001-1003 Chapter 21: Overview of Net8 for Client and Server QUESTION 37: Which task is recommended before you stop the listener? A. Shut down the instance. B. Disconnect all database users. C. Make a backup of your database. D. Send a warning message to all network users. Answer: D Explanation: Answer D is correct. It's better to send a warning message to all network users before you stop the listener. Incorrect Answers: A is incorrect; you don't need to shutdown instance to stop listener: the instance still can be up and running with stopped listener. Actualtests.com - The Power of Knowing 1Z0-026 B is incorrect; all database users will be disconnected automatically after stopping the listener. C is incorrect; you don't need to do a backup for you database before stopping the listener. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 999-1002 Chapter 21: Overview of Net8 for Client and Server QUESTION 38: How many region databases can be configured in a single administrative region of an Oracle directory object? A. 1 B. 2 C. 4 D. Unlimited Answer: A Explanation: Answer A is correct. Only one region database can be configured in a single administrative region of an Oracle directory object. Incorrect Answers: B is incorrect; only one region database can be configured, not two. C is incorrect; only one region database can be configured, not four. D is incorrect; only one region database can be configured, not unlimited amount. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1036-1043 Chapter 22: Names, Intelligent Agent, and MTS QUESTION 39: What is one responsibility of a listener? A. Routing out going traffic. B. Detecting lost connections. C. Detecting incoming requests. D. Passing statements and result tables. Answer: C Explanation: Answer C is correct. The main responsibility of a listener is detecting incoming requests. When the listener hears the incoming connection, the listener will either refuse the connection or allow the connection. A listener will refuse a connection if the user process requests a connection to an Oracle database that this listener does not listen for, if the user authentication information provided isn't valid, or if the Oracle database is not Actualtests.com - The Power of Knowing 1Z0-026 available. Incorrect Answers: A is incorrect; the listener is not responsible for routing out traffic, it detects only incoming requests. B is incorrect; the listener is not detecting lost connections. SMON background process cleans resources left locked after lost connections. D is incorrect; it does not pass statements and result tables. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 986-987 Chapter 21: Overview of Net8 for Client and Server QUESTION 40: Which two are features of Connection Manager? (Choose two) A. Connection exchange B. Connection resolution. C. Connection multiplexing. D. Connection crosslinking. E. Protocol transformation. F. Multiprotocol interchange capability. Answer: C, F Explanation: Answers C and F are correct. Connection Manager is used for connection multiplexing and it provides also multiple protocol support Incorrect Answers: A is incorrect; there is no connection exchange feature in Connection Manager. B is incorrect; there is no connection resolution feature in Connection Manager. C is incorrect; there is no connection crosslinking feature in Connection Manager. D is incorrect; there is no protocol transformation feature in Connection Manager. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1083 Chapter 23: Connection Manager, Troubleshooting, and Security QUESTION 41: Net8 Assistant can be used to configure a region database to be used by a Names server. Which two methods can be used to populate the database? (Choose two) A. Service names can be read from an existing names.ora file. B. Service names can be read from an existing tnsnames.ora file. C. Service names can be loaded by issuing the NAMESCTL>reload command. D. Service names can be loaded dynamically when the Names server is restarted. E. Service names can be manually entered by using the NAMESCTL>Load tnsnames command. Actualtests.com - The Power of Knowing 1Z0-026 Answer: B, C Explanation: Answers B and C are correct. To populate the database you can use service names from an existing tnsnames.ora file or by issuing the command RELOAD in the NAMECTL. Incorrect Answers: A is incorrect; you cannot load service names from an existing names.ora file. This file is used for configuring the Names server. D is incorrect; service names will not be loaded automatically when the Names server is restarted. You can use RELOAD command to force a check for data changes and reload new information, if any. E is incorrect; there is no LOAD tnsnames command in NAMECTL utility Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1054-1055 Chapter 23...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online