1Z0-026 Oracle8i: Network Administration Part 2

Oracle8i: Network Administration Part 2


Get Full Version on:http://www.getfreedumps.com/


QUESTION 11

When configuring for multiple protocol interchange, what does Source_Route indicate?
A. Enables connections through Connection Manager.
B. Identifies the service name to which the connection needs to be established.
C. Identifies the database SID to which the connection needs to be established.
D. Identifies the node and the port number on which connection manager is running.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer A is correct. Source_Route enables connections through Connection Manager.
Incorrect Answers:
B is incorrect; Source_Route parameter does not identify the service name to which the connection needs to be
established.
C is incorrect; Source_Route parameter does not identify the database SID to which the connection needs to
be established. SID parameter identifies it. D is incorrect; Source_Route parameter does not identify the node
and the port number on which connection manager is running. Host and Port parameters provide this
information.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1086-1091 Chapter 23: Connection Manager,
Troubleshooting, and Security

QUESTION 12

Which are two features of Connection Manager? (Choose two)
A. Connection exchange.
B. Connection resolution.
C. Connection multiplexing.
D. Connection cross-linking.
E. Protocol transformation.
F. Protocol interchange capability.
Correct Answer: CF
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answers C and F are correct. Connection multiplexing and multiprotocol interchange are two features of
Connection Manager.
Incorrect Answers:
A is incorrect; there is no connection exchange feature in the Connection Manager. B is incorrect; there is no
connection resolution feature in the Connection Manager. D is incorrect; there is no connection cross-linking
feature in the Connection Manager. E is incorrect; there is no protocol transformation feature in the Connection
Manager. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1082-1083 Chapter 23: Connection
Manager, Troubleshooting, and Security

QUESTION 13

Which two are tasks of the dispatcher process? (Choose two)
A. Receiving connection requests.
B. Placing a request in the request queue.
C. Updating the listener with new LOAD values.
D. Determining if the client request can be processed.
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answers B and C are correct. When MTS is being used, the listener passes the user process to another
process called a dispatcher. The user process will be handed off by the listener to the least busy dispatcher
process. The dispatcher process maintains two queues, called a request queue and a response queue. The
longer the request queue is at any given time, the more work a dispatcher has to accomplish on behalf of the
user process assigned it. The dispatcher process places a request in the request queue and update the listener
with new LOAD value, because try to balance dispatcher usage by calculating load volume for each dispatcher
at any given time.
Incorrect Answers:
A is incorrect; listener receives connection requests, not dispatcher processes. D is incorrect; dispatcher
processes is not used to determine if the client request can be processed.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1061-1063 Chapter 22: Names, Intelligent
Agent, and MTS

QUESTION 14

You are using host naming. Which components need to be installed?
A. Net8 on the server and the client machine.
B. TCP/IP and Net8 only on the client machine.
C. TCP/IP and Net8 only on the server machine.
D. TCP/IP and Net8 on the server and the client machine.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
Answer D is correct. To use the host naming method TCP/IP and Net8 need to be installed on the server and
the client machine.
Incorrect Answers:
A is incorrect; TCP/IP protocol need to be installed on the both machines, server and client.
B is incorrect; TCP/IP and Net8 on the server machine need to be installed as well. C is incorrect; TCP/IP and
Net8 on the client machine need to be installed as well. Oracle 8, DBA Certification Exam Guide, Jason S.
Couchman, p. 1009-1010 Chapter 21: Overview of Net8 for Client and Server

QUESTION 15

Which naming method simplifies administrative tasks when configuration changes need to be made available to
all clients immediately?
A. Host Naming
B. Local Naming
C. Service Naming
D. Centralized Naming
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer D is correct. When configuration changes need to be made available to all clients immediately,
centralized naming method simplifies administrative tasks.
Incorrect Answers:
A is incorrect; host naming is used for small database environments, where there are not a lot of users.
B is incorrect; local naming cannot be used for this purpose, because it will be required to change every
tnsnames.ora file for each client if configuration will be changed. C is incorrect; there is no service naming
connection method in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1036-1037
Chapter 22: Names, Intelligent Agent, and MTS
Get Full Version on:http://www.getfreedumps.com/


QUESTION 16

Which process picks up a request from a response queue?
A. Client process
B. Listener process
C. Dispatcher process
D. Shared server process
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer C is correct. When MTS is being used, the listener passes the user process to another process called a
dispatcher. The user process will be handed off by the listener to the least busy dispatcher process. The
dispatcher process maintains two queues, called a request queue and a response queue. The longer the
request queue is at any given time, the more work a dispatcher has to accomplish on behalf of the user process
assigned it. Dispatcher processes work with shared-server processes to accomplish the work that is in the
request queue. A shared server will grab the request at the beginning of the queue and process the work
requested. When the shared server is finished, it puts the information obtained from the Oracle database onto
the response queue, where the user process that made the request can pick up the results.
Incorrect Answers:
A is incorrect; dispatcher process picks up a request from a response queue on behalf of client process.
B is incorrect; listener process is used to provide connection for user process to the database, it does not work
with a response queue.
D is incorrect; shared server process puts the information onto the response queue, it picks up an initial request
from a request queue.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1061-1063 Chapter 22: Names, Intelligent
Agent, and MTS

QUESTION 17

If a password is configured, which command must be issued first when you need to stop the listener?
A. Stop
B. Password
C. Set Password
D. Shutdown immediate
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer C is correct. You can experience some problems with stopping your network listener process in batch if
you use the default password authentication requirement. If a password is configured "Set password" command
needs to be issued before stopping the listener.
Incorrect Answers:
A is incorrect; you need to use "stop" command only after setting password with "set password" command.
B is incorrect; there is no "password" command in LSNRCTL utility, only "set password" command.
D is incorrect; "shutdown immediate" command is used to shutdown database in Server Manager, not stop the
listener.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 999-1001 Chapter 21: Overview of Net8 for
Client and Server

QUESTION 18

Which parameter specifies the maximum number of server processes that get pre-spawned in a dedicated
server environment? (Do not use any extra words or characters)
A.
B.
C.
D.
Correct Answer:
Section: (none)
Explanation
Explanation/Reference:
Answer: MTS_MAX_SERVERS
Explanation:
The parameter MTS_MAX_SERVERS parameter specifies the maximum number of server processes that get
pre-spawned in a dedicated server environment. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman,
p. 1065-1066 Chapter 22: Names, Intelligent Agent, and MTS

QUESTION 19

Which statement regarding the logging and tracing of Net8 is True?
A. Logging cannot be disabled on client.
B. There are four levels of logging that can be set.
C. Tracing can take up significant disk space but has little impact on performance.
D. There is no way to prevent new trace data from being appended to the same file with each new session.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer B is correct. There are 4 levels of logging that can be set: from 1 to 4.
LOG_LEVEL parameter provides this information.
Incorrect Answers:
A is incorrect; logging can be disabled on client. Only tracing cannot be disabled on client. C is incorrect; tracing
has big impact on performance also. D is incorrect; it is possible to direct trace output information to the new
file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1095-1096 Chapter 23: Connection
Manager, Troubleshooting, and Security

QUESTION 20

The listener audit trail provides information about every client connection request. Which additional request
about the client is NOT provided?
A. Client user ID
B. Database user name
C. Network protocol
D. Client host (platform)
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Answer B is correct. The listener audit trail does not provide database user name about every client connection
request.
Incorrect Answers:
A is incorrect; the listener audit trail provides client user ID. C is incorrect; the listener audit trail provides
network protocol. D is incorrect; the listener audit trail provides client host. Oracle 8, DBA Certification Exam
Guide, Jason S. Couchman, p. 1093-1101 Chapter 23: Connection Manager, Troubleshooting, and Security
Get Full Version on:http://www.getfreedumps.com/

Comments

Popular posts from this blog

1z0-020 Oracle8i: New Features for Administrators Part 2

1Z0-023 Oracle8i: Architecture and Administration Part 2

1Z0-024 Oracle8i: Performance and Tuning Part 3