1Z0-026 Oracle8i: Network Administration Part 2
Oracle8i: Network Administration Part 2
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
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
Post a Comment