Oracle OCP Network Questions
|
Question:
1. When it is important to provide an
Oracle database that will be able to start small and later
support thousands of users, the best approach would be:
Answer:
A. TCP/IP
Answer:
B. Real Application Clusters
Answer:
C. Oracle*Net with SQL*Net
Answer:
D. IBM SNA
Correct Answer:
B. Real Application Clusters
Explanation:
The correct answer is (D) Real
Application Clusters. When it is important to provide an Oracle
database that will be able to start small and later support
thousands of users, the best approach would be OPS. A is
incorrect because TCP/IP is a protocol, and this would not help
with scalability. C is incorrect because Oracle*Net is only
used for distributed systems and does not address scalability.
D is incorrect because IBM SNA is a mainframe gateway and has
nothing to do with scalability. B is correct because OPS
provide for the ability for many processors to share a single
Oracle database. As the number of users increases, the number
of processors can be increased.
Question:
2. The most popular communication
protocol for Oracle*Net on UNIX systems is:
Answer:
A. TCP/IP
Answer:
B. SPX
Answer:
C. SNA
Answer:
D. DecNet
Correct Answer:
A. TCP/IP
Explanation:
The correct answer is A TCP/IP. The most
popular communication protocol for Oracle*Net on UNIX systems
is: B C and D are incorrect because there are not widely-used
communications protocols. The UNIX operating system makes
TCP/IP the most popular protocol.
Question:
3. The popularity of the Internet has
created which of the following scenarios?
Answer:
A. Widely distributed Oracle database
across a wide area network.
Answer:
B. Distributed databases with WebServer
gateways.
Answer:
C. Networks of networked databases.
Correct Answer:
B. Distributed databases with WebServer
gateways.
Explanation:
The correct answer is B Distributed
databases with WebServer gateways. The popularity of the
Internet has created which of the following scenarios? A is
incorrect because WAN Oracle systems are not on the Internet. C
is incorrect because networked database do not impact the
Internet. Oracle WebServer is the networking tools that allows
an Internet user to access an Oracle database.
Question:
1. Which is not a valid way to
establish an initial connection to an Oracle database?
Answer:
A. With a TNS connect string
(t:host:database).
Answer:
B. With a database link (select * from
customer@ny;)
Answer:
C. With a server connect string (sqlplus
/@fred)
Answer:
D. With a telnet session.
The correct answer is D, with a telnet
session.
Explanation:
The correct answer is D, with a telnet
session. Which is not a valid way to establish an initial
connection to an Oracle database? A, B, and C are incorrect
because they are all valid ways to establish a database
connection. A telnet session will only establish connections
with a server, not the database.
Question:
2. What Oracle meta table is used to
view database link information?
Answer:
A. Remote DBA_TABLES
Answer:
B. Remote DBA_DB_LINKS
Answer:
C. Remote DBA_SYNONYMS
Answer:
D. Remote DBA_2PC_PENDING
Correct Answer:
B. Remote DBA_DB_LINKS
Explanation:
The correct answer is B. Remote DBA_DB_LINKS.
What Oracle meta table is used to view database link
information? A is incorrect because Remote DBA_TABLES only views table
information. C is incorrect because Remote DBA_SYNONYMS is only used
to view synonyms. D is incorrect because Remote DBA_2PC_PENDING is
only used to view two-phase commit transactions.
Question:
3. What file(s) are used to supply the
server IP address? (choose all that apply)
Answer:
A. The /etc/hosts file
Answer:
B. The /etc/services file
Answer:
C. The tnsnames.ora file
Answer:
D. The sqlnet.ora file
Correct Answer:
The correct answers are A and C
Explanation:
The correct answers are A and C, the
/etc/hosts file and the tnsnames.ora file. What file(s) are used
to supply the server IP address? B is incorrect because
/etc/services supplies only port numbers. D is incorrect
because sqlnet.ora only supplies Oracle client information.
Question:
4. Which of the following files
supplies the protocol information for outgoing Oracle requests?
Answer:
A. listener.ora
Answer:
B. sqlnet.ora
Answer:
C. /etc/hosts
Answer:
D. tnsnames.ora
Correct Answer:
D. tnsnames.ora
Explanation:
The correct answer is D, tnsnames.ora.
Which of the following files supplies the protocol information
for outgoing Oracle requests? A is incorrect because the
listener.ora file is only for incoming requests. B is incorrect
because sqlnet.ora is only for Oracle*Net clients. C is
incorrect because /etc/hosts pairs the host name to the IP
address.
Question:
1. The purpose of the tnsnames.ora file
is best described as:
Answer:
A. A process that listens for incoming
database connections.
Answer:
B. A file that is used to supply host,
protocol and database information for incoming requests.
Answer:
C. A file that is used to hide the
details about what is needed to connect to a remote database.
Answer:
C. A file that is used to hide the
details about what is needed to connect to a remote database.
Correct Answer:
The correct answer is C. A file that is
used to hide the details about what is needed to connect to a
remote database.
Explanation:
The correct answer is C. A file that is
used to hide the details about what is needed to connect to a
remote database. The purpose of the tnsnames.ora file is best
described as: A is incorrect because the listener process, not
the listener.ora file listeners for connections. B is incorrect
because the tnsnames.ora file is used for OUTGOING requests, not
incoming requests. D is incorrect because the tnsnames.ora file
is not a process. The tnsnames.ora file is a file that is used
to hide the details about what is needed to connect to a remote
database. The tnsnames.ora is a file that “pairs” the service
name with the host name, the protocol, and the database name.
Question:
2. If we are exploring a new Oracle*Net
computer and we do not know if it is configured to act as an
Oracle server, what file would we look for?
Answer:
A. tnsnames.ora
Answer:
B. sqlnet.ora
Answer:
C. listener.ora
Answer:
D. protocol.ora
Correct Answer:
C. listener.ora
Explanation:
The corrrect answer is C. listener.ora.
If we are exploring a new Oracle*Net computer and we do not know
if it is configured to act as an Oracle server, what file would
we look for? A, B, and C are incorrect because these files are
only used by Net clients. An Oracle Server must have a listener
process defined in order to be considered a Oracle*Net server.
Question:
3. What best describes a database link?
Answer:
A. A software component that assists in
establishing connectivity with remote servers.
Answer:
B. An internal Oracle component that
adds a USER ID and password to a TNS service name.
Answer:
C. A component that makes the physical
connections to the Oracle database, establishing a server
process.
Answer:
D. A tool to define the Oracle*Net
environmental files.
Correct Answer:
B. An internal Oracle component that
adds a USER ID and password to a TNS service name.
Explanation:
The correct answer is B. An internal
Oracle component that adds a USER ID and password to a TNS
service name. What best describes a database link? A is
incorrect because a database link is not software, it is an
entry in the Oracle dictionary. C is incorrect because database
links to not make database connections, and this is done by the
listener process. D is incorrect because database links do not
define environments. Database links are internal database
components that are stored in the Oracle dictionary. They
consist of the link name, the TNS name, the user ID and the
password.
Question:
4. The main shortcoming of SQL*Net
version 1 is that:
Answer:
A. It did not have the ability to
establish communications between multiple protocols.
Answer:
B. It did not possess a listener
process.
Answer:
C. It did not have the ability to use
connect strings
Correct Answer:
A. It did not have the ability to
establish communications between multiple protocols.
Explanation:
The correct answer is A. It did not
have the ability to establish communications between multiple
protocols. The main shortcoming of SQL*Net version 1 is that: B
is incorrect because SQL*Net v 1 uses a listener called ORASRV.
C is incorrect because SQL*Net v 1 does use connect strings.
One of the features of SQL*Net version 2 is the ability to
support multi-protocol “communities”.
Question:
5. Which of the following components is
NOT used by the Oracle listener?
Answer:
A. listener.ora
Answer:
B. tnsnames.ora
Answer:
C. database link information
Answer:
D. Dispatcher process
Correct Answer:
B. tnsnames.ora
Explanation:
The correct answer is B tnsnames.ora.
Which of the following components is NOT used by the Oracle
listener? A is incorrect because the listener.ora is used by
the listener at start-up time. C is incorrect because database
link information is used by the listener to get the TNS service
name. D is incorrect because the dispatcher processes are used
by the listener to channel incoming database requests. The
tnsnames.ora file is ONLY used by the remote client, and not the
receiving server.
Question:
Which is not true about the tnsnames.ora
file?
Answer:
The tnsnames.ora file provides the
network-specific details about the remote database
Answer:
The tnsnames.ora file should use the
host name, and not the actual remote server IP address
Answer:
The tnsnames.ora file contains
everything that is need to connect to the remote database
Answer:
The tnsnames.ora file should contain
port number of the remote server
Correct Answer:
C
Explanation:
The tnsnames.ora file does not contain
the USER ID or password. That must be supplied manually, or
through a database link
Question:
Which of the following components
controls the connection to the remote database?
Answer:
The tnsnames.ora file
Answer:
The database link
Answer:
The TNS listener
Answer:
The protocol.ora file
Correct Answer:
C
Explanation:
The listener establishes the connection
to the remote database and create the initial hookup.
Question:
What is not contained in a database
link?
Answer:
The remote USER ID
Answer:
The host name of the remote server
Answer:
The TNS service name
Answer:
The remote password
Correct Answer:
B
Explanation:
The host name of the remote server is in
the tnsnames.ora file, not in the database link.
Question:
With is not true about a Oracle*Net
connection?
Answer:
The Oracle*Net client establishes the
server process for the request
Answer:
The service name is used to perform the
look-up in the tnsnames.ora file
Answer:
Database links and Oracle*Net are both
required for remote SQL connections
Answer:
The protocol.ora file contains
cross-protocol information
Correct Answer:
A
Explanation:
The remote listener, not the client,
establishes the request.
Question:
Which is not a part of a Oracle*Net
client install?
Answer:
Starting the TNS listener process
Answer:
Installing the Oracle*Net client
software
Answer:
Configuring the tnsnames.ora file
Correct Answer:
A
Explanation:
The listener process exists only on the
server, not on the client.
Question:
Which of the following characteristics
of Oracle*Net is false?
Answer:
Resource consumption in Oracle*Net is
greatest for the requesting client processor
Answer:
The protocol.ora file allows for
inter-protocol communications
Answer:
The listener process exists only on
Oracle servers
Answer:
For a distributed query, database links
must exist only on the client database
Correct Answer:
A
Explanation:
Almost 100% of the processing work is
done on the remote server, not on the requesting client.
Question:
The remote database name is kept in
which Oracle parameter file?
Answer:
Sqlnet.ora
Answer:
Tnsnames.ora
Answer:
Protocol.ora
Answer:
None: It is kept in the database link
Correct Answer:
Tnsnames.ora
Explanation:
The tnsnames.ora file contains the port
number, the database name, the protocol, and the host name.
Question:
Which of the following is not always
contained in the tnsnames.ora file?
Answer:
Port number
Answer:
Host name
Answer:
IP address
Answer:
protocol
Correct Answer:
IP address
Explanation:
The IP address might be present in the
tnsnames.ora file, but most Remote DBA’s use the host name instead, to
you do not have frequent changes to the tnsnames.ora file.
Question:
How do you hide the fact that a table is
being used at a remote database?
Answer:
Create a database synonym
Answer:
Create an alias in the tnsnames.ora file
Answer:
Provide a dedicated listener process on
the remote server
Answer:
Make the service name the same as the
database name in the tnsnames.ora file
Correct Answer:
A
Explanation:
Location transparency is achieved by
creating a synonym for the remote table name:
Create public synonym customer for
customer@raleigh;
Question:
Which is not true about dedicated
listener processes?
Answer:
The listener process can be seen with a
UNIX command
Answer:
The Oracle*Net connections can be seen
by querying the v$ views at the remote database
Answer:
The listener is required for all
Oracle*Net clients
Answer:
The listener is started on each remote
database server.
Correct Answer:
C
Explanation:
Only Oracle servers require a listener
process
Question:
Which of the following are true about
the tnsnames.ora file?
Answer:
The tnsnames.ora file is not required
for Oracle servers
Answer:
Most PC clients create individual
tnsnames.ora files
Answer:
The Remote DBA usually maintains a “master”
tnsnames.ora file
Answer:
The tnsnames.ora file contains the
database name for the remote database
Correct Answer:
A & C
Explanation:
Only Oracle clients require a
tnsnames.ora file, and the Remote DBA normally maintains a master
tnsnames.ora file for use throughout the corporation.
?
Question:
Which is not true about Dead client
detection?
Answer:
The dead client detection is specified
in the sqlnet.ora file.
Answer:
Dead client detection polls the server a
pre-determined intervals.
Answer:
Dead connection poll times are specified
with the expire_time parameter
Answer:
Dead connections are terminated on the
client and the server
Correct Answer:
D
Explanation:
Since the connection is dead, the Oracle
server process that was initiated by the client may continue to
run.
Question:
Which of the following is NOT a valid
type of listener?
Answer:
A listener that is polling on 3
addresses for 3 different protocols
Answer:
A listener that passes requests to a
multi-threaded dispatcher.
Answer:
A listener that makes a direct
connection to the Oracle database.
Answer:
A listener that allows SNMP connections
from a mainframe
Correct Answer:
C
Explanation:
Listeners do not make direct connections
to the database. They bequeath the connections.
Question:
Which command is used to start a SQL*Net
version 1 listener?
Answer:
tcpctl start
Answer:
tcpctl start listener
Answer:
lsnrctl start
Answer:
Lsnrctl start listener
Correct Answer:
A
Explanation:
This is the correct command for SQL*Net
version 1
Question:
What is the main disadvantage to using
Oracle*Net assistant?
Answer:
It is not practical for large Oracle
networks because manually created parameter files cannot always
be processed.
Answer:
It is easily to manually edit the
parameter files.
Answer:
The Oracle*Net assistant does not have
the flexibility of manual editing.
Answer:
The Oracle*Net assistant wizards are not
very intuitive
Correct Answer:
A
Explanation:
Some manually created tnsnames.ora and
listener.ora files cannot be read by Oracle*Net assistant.
Question:
If you have very high connection
volumes, what is the best approach for configuring the listener?
Answer:
Create multiple listeners on the server
Answer:
Create a multi-protocol listener
Answer:
Create the listener with additional
service handlers
Answer:
Create a multi-threaded server for each
database.
Correct Answer:
D
Explanation:
The MTS is the best way to handle high
volumes of data
Question:
What command is used to see the
available listener control commands?
Answer:
tcpctl help
Answer:
lsnrctl syntax
Answer:
lsnrctl help
Answer:
lsnrctl ?
Correct Answer:
C
Explanation:
The lsnrctl help command will show the
available listener commands
Question:
Which is NOT true about a Oracle*Net
listener?
Answer:
The listener contains an entry for each
database on the host.
Answer:
The listener process will start
automatically when the database is started
Answer:
The listener runs as an independent
process on the server
Answer:
The listener can be “bounced” without
effecting existing connections
Correct Answer:
B
Explanation:
The listener must be started as a
separate process with the “lsnrctl start” command.
Question:
Which is NOT true about Oracle*Net
multi-protocol support?
Answer:
Multi-protocol support requires defining
a multi-threaded server for each database.
Answer:
Oracle*Net protocols are defined in the
listener.ora file
Answer:
The Oracle*Net connection manager can be
used in lieu of multi-protocols in the listener.ora file.
Answer:
The Oracle*Net listener can support
protocols from PC’s, mainframes, and virtually every type of
remote protocol.
Correct Answer:
A
Explanation:
The MTS is not required for
multi-protocol support.
Question:
In what directory would you find the
Oracle*Net executable files?
Answer:
C:\orawin\execlib
Answer:
C:\win32\bin
Answer:
C:\orant\Oracle*Net0\network\admin
Answer:
C:\orant\bin
Correct Answer:
D
Explanation:
The Oracle*Net executables are located
in the “bin” directory
Question:
The PC that you have been given is
running Windows NT with Net7 and does not have Oracle*Net
assistant installed. You need to add a new remote database
description. What file would you edit to do this?
Answer:
c:\orant\Oracle*Net0\admin\tnsnames.ora
Answer:
c:\orant\Oracle*Net0\network\admin\tnsnames.ora
Answer:
c:\orant\network\admin\tnsnames.ora
Answer:
c:\orant\Oracle*Net0\admin\sqlnet.ora
Correct Answer:
D
Explanation:
This is the location of the tnsnames.ora
Question:
What type of Oracle shop is most likely
to use the Oracle*Net assistant?
Answer:
A large Oracle shops with thousands of
PC’s.
Answer:
A small Oracle shop with a small number
of client PC’s.
Answer:
A small Oracle shop with
highly-technical end-users.
Answer:
A large Oracle shop with dozens of
remote databases.
Correct Answer:
C
Explanation:
Oracle*Net assistant is not an end-user
tool, and requires some knowledge of TNS. It is also unsuited
to large Oracle shops.
Question:
If you fail in an attempt to ping a
remote server by host name, what is the best course of action?
Answer:
Get a systems administrator to check the
services file on your PC.
Answer:
Try to ping the server using the IP
address of the remote computer
Answer:
Try connecting with SQL*Plus
Answer:
See if the listener is running on the
remote server
Correct Answer:
B
Explanation:
If you cannot ping by host name, see if
you can ping with the IP address. If that fails, you have a
domain name server problem, if not you have a problem with your
services file.
Question:
Which of the following statements is
true?
Answer:
It is possible to connect to an Oracle8
database with Oracle7 client software.
Answer:
It is always a good idea to use a shared
tnsnames.ora file on a networked disk.
Answer:
The best way to test a TNS problem is
with the ping utility.
Answer:
You should always install the Oracle*Net
assistant on a PC Oracle client.
Correct Answer:
A
Explanation:
The Oracle client software is totally
independent and backward-compatible.
Question:
What is the best method for propagating
a tnsnames.ora file to PCs?
Answer:
Use a third-party software package to
distribute the file
Answer:
Send all users an e-mail with the file
whenever it changes
Answer:
Share the tnsnames.ora file on a PC
network disk
Answer:
All of the above are acceptable
Correct Answer:
D
Explanation:
There are many approaches to managing
the tnsnames.ora file
Question:
Which of the following files will never
appear in the /network/admin directory of a PC client?
Answer:
Listener.ora
Answer:
Topology.ora
Answer:
Sqlnet.ora
Answer:
Tnsnames.ora
Correct Answer:
A
Explanation:
A PC client will never have a
listener.ora file unless it is an NT server with an Oracle
database.
Question:
What is not true about SQL*Net Easy?
Answer:
It will perform a test of the
connectivity at the end of the session.
Answer:
It will interrogate the server to get
the proper port number
Answer:
It will allow you to provide a service
name that is different from the database name
Answer:
It will allow you to scroll back if you
make a mistake
Correct Answer:
B
Explanation:
You need to know the port number when
you add the database name.
Question:
What is the best choice for installing
Oracle*Net clients on thousands of PCs?
Answer:
The Oracle Remote DBA should perform all Oracle
installs.
Answer:
A non-Oracle technician can be trained
to install the clients
Answer:
Oracle client software should only be
installed by a system administrator
Answer:
The LAN administrator should install all
Oracle client software
Correct Answer:
B
Explanation:
It is not necessary for the Oracle Remote DBA
to perform all Oracle client install, and non-Oracle technicians
can be trained to perform this repetitive task.
Question:
1. Which of the following sites would
most likely to use Oracle Names?
Answer:
A small shop with frequent database
domain changes
Answer:
A large shop with frequent database
domain changes
Answer:
A small shop with infrequent database
domain changes
Answer:
A large shop with infrequent database
domain changes
Correct Answer:
A
Explanation:
Oracle Names is best for small shops
that have frequent new or changed database domains.
Question:
2. How does Oracle address the “single
point of failure” issue with Oracle Names?
Answer:
By allowing the manual propagation of
the tnsnames.ora file
Answer:
By supporting the automatic propagation
of the tnsnames.ora file
Answer:
By allowing for multiple Names Servers
Answer:
By maintaining constant polling
connections
Correct Answer:
C
Explanation:
Multiple Names Servers relieves the
single point of failure problem.
Question:
3. What is the purpose of the
names.ora file?
Answer:
To define the Names Server to all
Oracle*Net clients
Answer:
To configure the Names database on the
Oracle server
Answer:
To define all TNS connections to remote
servers
Answer:
To define the database links to remote
databases
Correct Answer:
B
Explanation:
The names.ora file determines the
configuration of the Names database on the Names Server.
Question:
4. Where does Oracle Names store
database link information?
Answer:
In the names.ora file
Answer:
In the sqlnet.ora file
Answer:
The links are read dynamically from each
remote database
Answer:
In the Names database
Correct Answer:
D
Explanation:
The Names database stores all TNS
information, including IP addresses, ports, host names,
protocols, database links, user ID’s and passwords.
Question:
5. Which files are required on an
Oracle Names client PC? (Choose all that apply)
Answer:
The tnsnames.ora file
Answer:
The sqlnet.ora file
Answer:
The listener.ora file
Answer:
The names.ora file
Correct Answer:
B
Explanation:
Only the sqlnet.ora file is required on
a Names client PC.
Question:
1. The command syntax of the namesctl
utility has the most in common with which utility?
Answer:
The Oracle*Net assistant utility
Answer:
The SQL*Net Easy utility
Answer:
The lsnrctl utility
Answer:
The tcpctl utility
Correct Answer:
C
Explanation:
The command syntax between lsnrctl and
namesctl is very similar.
Question:
2. Which is not an issue when deciding
whether to implement Oracle Names?
Answer:
The volatility of the database
environment
Answer:
The number of database on each server
Answer:
The reliability requirements of the
network
Answer:
The number of PC clients at the site
Correct Answer:
B
Explanation:
The number of database on each server is
not a factor in deciding whether to use Oracle Names.
Question:
3. Which statement is false about
Oracle Names?
Answer:
Oracle Names is required for Oracle*Net
implementation
Answer:
Oracle Names assists in the maintenance
of the tnsnames.ora files
Answer:
Oracle Names will store database link
information in a central location
Answer:
Oracle Names can be used to simplify
Oracle*Net maintenance
Correct Answer:
A
Explanation:
Oracle Names is an optional product.
Question:
4. Which of the following is not a step
in the resolution of an Oracle Names request?
Answer:
Passing the service name to the Oracle
Names Server
Answer:
Gathering the database link USER ID and
password
Answer:
Getting the host address from the Names
Server
Answer:
Resolving the protocol in the
tnsnames.ora file
Correct Answer:
D
Explanation:
A tnsnames.ora file is not used with
Oracle names.
Question:
1. Which OEM console window would be
used to cancel a server process?
Answer:
A. Navigator window
Answer:
B. Job scheduling window
Answer:
C. Map window
Answer:
D. Event manager window
Correct Answer:
B. Job scheduling
Explanation:
The correct answer is B, job
scheduling. This is because the job scheduler allows interfaces
with the remote operating system, including killing a task.
Which OEM console window would be used to cancel a server
process? A, and C, are clearly incorrect because they do not
allow for O/S kill commands to be directly issued. D might have
been a choice because the event manager could issue a kill
command via SNMP, but B is a better answer because the job
scheduled is designed for this function.
Question:
2. What OEM console window is used to
display all of the tables for an Oracle user?
Answer:
A. Navigator window
Answer:
B. Job scheduler window
Answer:
C. Map window
Answer:
D. Event manager window
Correct Answer:
A. Navigator window
Explanation:
The correct answer is A, navigator
window because this window displays all of the databases, users,
within each database, tables for each user, and attributes for
all table.
What OEM console window is used to
display all of the tables for an Oracle user? B, C, and D are
incorrect because they do not display Oracle table information.
Question:
3. The OEM console navigator is very
similar to what other Oracle GUI tool?
Answer:
A. Oracle*Net Easy
Answer:
B. Schema Manager
Answer:
C. Tablespace manager
Answer:
D. Data manager
Correct Answer:
B. Schema manager
Explanation:
The correct answer is B, schema manager,
because both schema manager and the navigator allow for the
hierarchical display of databases, users table, and table
attributes. The OEM console navigator is very similar to what
other Oracle GUI tool? A is incorrect because Oracle*Net Easy
is used to add service names to the tnsnames.ora file. C is
incorrect because tablespace manager is used to display
sequential blocks within a list if tablespaces. D is incorrect
because data manager is used to add files to a tablespace.
Question:
4. Which window of the OEM console
would be used to display the size of a remote database SGA?
Answer:
A. Navigator window
Answer:
B. Job scheduler window
Answer:
C. Map window
Answer:
D. Event manager window
Correct Answer:
C. Map window
Explanation:
The correct answer is C, map window
because double clicking on a database icon in the map window
will display all of the relevant SGA sizes. Which window of the
OEM console would be used to display the size of a remote
database SGA? A, B, and D are incorrect because they do not
display SGA information.
Question:
What is the downside to defining too
many dispatchers?
Answer:
Incoming connections will have to wait
for the listener.
Answer:
There will be unnecessary extra server
processes.
Answer:
There will be excessive connect times
for dedicated connections
Correct Answer:
B
Explanation:
The correct answer is B, there will be
unnecessary extra server processes. This is because extra UNIX
PID’s will be allocated for each dispatcher. A and C are
incorrect because extra dispatchers will not effect connection
times.
Question:
What is false about the mts_dispatcher
init.ora parameter?
Answer:
You can define multiple protocols for
each dispatcher.
Answer:
You can define many dispatcher processes
with this parameter.
Answer:
You can define the target protocol for
the dispatcher with this parameter.
Correct Answer:
A
Explanation:
The correct answer is A, You can define
multiple protocols for each dispatcher. This is necause a
dispatcher may only support a single protocol. What is false
about the mts_dispatcher init.ora parameter? B and C are
incorrect because they are proper uses for the mts_dispatcher
parameter.
Question:
What is false about the MTS?
Answer:
All SQL*Net version 1 connections will
continue to use a dedicated connection.
Answer:
The MTS will place an additional burden
on the Oracle shared pool.
Answer:
The MTS requires that you define at
least one dispatcher.
Answer:
You cannot use a dedicated connection if
the MTS is defined.
Correct Answer:
D
Explanation:
The correct answer is D, You cannot use
a dedicated connection if the MTS is defined. This is because
you can explicitly request a dedicated connection in your
Oracle*Net connect string. What is false about the MTS? A, B.
and C are incorrect because they are valid MTS statements.
Question:
Which of the following operations is not
permitted through an MTS connection?
Answer:
Creating an Oracle table.
Answer:
Stopping an Oracle database.
Answer:
Querying the v$dispatcher view.
Answer:
Changing the init.ora file
Correct Answer:
B
Explanation:
The correct answer is B, Stopping an
Oracle database. This is because you cannot connect to Server
Manager via an MTS connection. Which of the following operations
is not permitted through an MTS connection? A is incorrect
because you can do any DDL through the MTS. C is incorrect
because the dictionary does not care how the connection is
established. D is incorrect because Oracle connectivity is not
required to change the init.ora file.
Question:
Which parameter is used to define
connection pooling?
Answer:
mts_servers
Answer:
mts_dispatchers
Answer:
mts_listener_address
Answer:
mts_pool
Correct Answer:
B
Explanation:
The correct answer is B,
mts_dispatchers. Which parameter is used to define connection
pooling? A, C, and D are incorrect because they are not used to
configure connection pooling.
Question:
What is the procedure used to compute
the “busy rate” for an MTS?
Answer:
Query the v$queue view.
Answer:
Query the v$dispatcher view.
Answer:
Run the equation for busy rate.
Answer:
Count the high-water mark for connected
processes.
Correct Answer:
B
Explanation:
The correct answer is B, Query the
v$queue view. What is the procedure used to compute the “busy
rate” for an MTS?
Question:
How can you get the “average wait time
per transaction” from the MTS?
Answer:
The v$queue view
Answer:
The v$dispatcher view
Answer:
The v$sga view
Answer:
The listener.log
Correct Answer:
A
Explanation:
The correct answer is A, the v$queue
view. How can you get the “average wait time per transaction”
from the MTS? B, C, and D are incorrect because they do not
contain wait time information.
Question:
Which is not a task in listener load
balancing?
Answer:
Adjusting shared servers for each MTS.
Answer:
Adjusting the shared_pool_size
Answer:
Adjusting the number of listener
processes on the server.
Answer:
Adjusting the number of dispatchers for
each MTS.
Correct Answer:
B
Explanation:
The correct answer is B, adjusting the
shared_pool_size. Which is not a task in listener load
balancing? A, C and D are incorrect because they are all
relevant tasks when adjusting the listeners.
Question:
What is false about shared server
process configuration?
Answer:
Shared server processes will be
automatically allocated when needed.
Answer:
You should set mts_shared_servers to a
high initial value.
Answer:
Shared server processes will be
de-allocated when they are not needed.
Answer:
Shared server processes communicate with
the dispatcher processes.
Correct Answer:
B
Explanation:
The correct answer is B, You should set
mts_shared_servers to a high initial value. This is because
Oracle automatically allocates shared servers as needed, and a
high initial allocation will waste resources. What is false
about shared server process configuration? A, C, and D are
incorrect because they are valid statements about the shared
server.
Question:
Which is not a valid parameter for the
cman.ora rules section?
Answer:
ACT
Answer:
DST
Answer:
SRV
Answer:
ORA
Correct Answer:
D
Explanation:
The correct answer is D, ORA because ORA
is not a valid cman_rules directive. Which is not a valid
parameter for the cman.ora rules section? A, B, and C are valid
because they are valid directives for the cman_rules section of
the cman.ora file.
Question:
What does the SRV rules parameter of the
cman.ora file specify?
Answer:
The TNS service name
Answer:
The remote server name
Answer:
The location of the tnsnames.ora file
Answer:
The location of the cman.ora file.
Correct Answer:
B
Explanation:
The correct answer is B, the remote
server name. This is because the SRV sub-parameter of the
cman_rules section is used to specify the name of a remote
server. What does the SRV rules parameter of the cman.ora file
specify? A, C, and D are incorrect because they are not
effected by the SRV paramater.
Question:
What is not a valid section of the
cman.ora file?
Answer:
cman_rules
Answer:
cman
Answer:
cman_connection
Answer:
cman_profile
Correct Answer:
D
Explanation:
The correct answer is D, cman_profile
because it is not a valid cman.ora section name. What is not a
valid section of the cman.ora file? A, B, and C are incorrect
because they are valid cman.ora sections.
Question:
If you wish to reject a connection from
a specified host, what cman.ora sub-parameter would be used?
Answer:
ORA
Answer:
ACT
Answer:
DST
Answer:
SRV
Correct Answer:
B
Explanation:
The correct answer is B, ACT. This is
because the ACT sub-parameter of the cman_rules section of the
cman.ora file is used to reject connections. If you wish to
reject a connection from a specified host, what cman.ora
sub-parameter would be used? A, C, and D are incorrect because
they do not control host rejection.
Question:
Which of the following statements is
false regarding CMAN?
Answer:
The CMAN utility does not support
multiple protocols.
Answer:
The CMAN utility can be used together
with a traditional Oracle*Net listener.
Answer:
The CMAN utility can selectively accept
remote connections from specific servers.
Answer:
The CMAN utility can be used to
concentrate connections into a multi-threaded server.
Correct Answer:
A
Explanation:
The correct answer is A, The CMAN
utility does not support multiple protocols. This is because
the CMAN utility does indeed support many protocols. Which of
the following statements is false regarding CMAN? B, C, and D
are incorrect because they are true statements about CMAN.
?
Question:
Which is not a benefit of the Connection
Manager?
Answer:
Multiprotocol support
Answer:
Data encryption
Answer:
Connection concentration
Answer:
Network access control
Correct Answer:
B
Explanation:
The correct answer is B, data encryption
because encryption is not a CMAN function. Which is not a
benefit of the Connection Manager? A, C, and D are correct
because they are valid CMAN features.
Question:
The connection concentration feature has
the most in common with what other Oracle product feature?
Answer:
The MTS connection pooling feature.
Answer:
The MTS multiple dispatcher feature.
Answer:
The SQL*Net multi-protocol feature.
Answer:
The Oracle*Net tnsnames.ora POOL option.
Correct Answer:
A
Explanation:
The correct answer is A, The MTS
connection pooling feature. This is because the MTS connection
pooling routes requests to a shared server just like the CMAN
utility. The connection concentration feature has the most in
common with what other Oracle product feature? B, C, and D are
incorrect because they have nothing to do with connection
pooling.
Question:
What best describes the purpose of the
CMAN administrator process?
Answer:
It is a process that is responsible for
maintaining address information in the Oracle Names Server for
the Oracle*Net clients.
Answer:
It is a process that manages the
connections to the multi-threaded servers on each database.
Answer:
It is a process that implements
connection concentration for each database instance.
Answer:
It is a process that listens for
incoming connections.
Correct Answer:
A
Explanation:
The correct answer is A, it is a process
that is responsible for maintaining address information in the
Oracle Names Server for the Oracle*Net clients. What best
describes the purpose of the CMAN administrator process? B, C,
and D are incorrect because they are not valid functions of the
CMAN administrator.
Question:
What is the first thing that should be
done when a end-user cannot connect to a server?
Answer:
Check the local tnsnames.ora file
Answer:
Look-up the error number provided to the
end-user
Answer:
Try to ping the server.
Answer:
Check the listener
Correct Answer:
B
Explanation:
The correct answer is B, look-up the
error number provided to the end-user. What is the first thing
that should be done when a end-user cannot connect to a server?
A, C, and D are incorrect because they are secondary steps in
problem resolution.
Question:
What statement is most correct about
trace files?
Answer:
Trace files are automatically generated
and are very useful for diagnosing common connection problems.
Answer:
Trace files are relatively small and can
be kept as a record of Oracle*Net connections.
Answer:
Trace files are very useful ONLY if
Oracle auditing is also used.
Answer:
Trace files are large and space
consuming and should only be used in rare cases.
Correct Answer:
D
Explanation:
The correct answer is D, trace files are
large and space consuming and should only be used in rare cases.
What statement is most correct about trace files? A, B, and C
are incorrect because they do not correctly describe trace
files.
Question:
You receive a report from dozens of
end-users, all complaining that they cannot connect to the
server. What log file should you check first?
Answer:
sqlnet.log
Answer:
listener.log
Answer:
tnsnames.log
Answer:
alert.log
Correct Answer:
B
Explanation:
The correct answer is B, listener.log.
You receive a report from dozens of end-users, all complaining
that they cannot connect to the server. What log file should
you check first? A, C. and D are incorrect because they do not
address the listener, which is generally the sole cause of
large-scale problems.
Question:
What trace component can be started
without making the end-users exit and re-connect to the server?
Answer:
listener trace
Answer:
server trace
Answer:
sqlnet trace
Answer:
names trace
Correct Answer:
A
Explanation:
The correct answer is A, listener trace
with “lsnrctl trace”. What trace component can be started
without making the end-users exit and re-connect to the server?
B. C, and D are incorrect because they involve re-connecting to
the database.
Question:
Which is not a valid trace level for
Oracle?
Answer:
USER
Answer:
ADMIN
Answer:
OFF
Answer:
TRACE
Correct Answer:
D
Explanation:
The correct answer is D, TRACE. Which is
not a valid trace level for Oracle? A, B, and C are incorrect
because they are valid level parameters for Oracle tracing.
Question:
Which level of tracing will provide the
highest level of detail about a connection?
Answer:
USER
Answer:
ADMIN
Answer:
OFF
Answer:
TRACE
Correct Answer:
D
Explanation:
The correct answer is B, ADMIN. Which
level of tracing will provide the highest level of detail about
a connection? A, C, and D are incorrect because they are
lower-detail
Question:
You have forgotten the location of your
listener log files. What is the best way to determine their
location?
Answer:
Server manager – show parameters dump
Answer:
Run tnsping
Answer:
Run lsnrctl stat
Answer:
Check tnsnames.ora
Correct Answer:
C
Explanation:
The correct answer is C, lsnrctl stat.
You have forgotten the location of your listener log files.
What is the best way to determine their location? A, B, and D
are incorrect because they are not the best way to see the
location of your listener.log file.
|
