RelationalDBDesign
SiteMap
Network Config
Network Admin
Network Topology
Serverside Configuration
«Prev
Next»
Network Topology
Oracle Certification
Networking Overview
History Oracle Networking
Evolution Network Protocols
Oracle Networked Computers
DB Evolution
Distributed Data
Distributed DB Features
Local Autonomy
Fragmentation Independence
Oracle Topology Overview
DB Links Connectivity
Join Tables Remote Sites
TNS
Inter Communication
SQL App Connection
SQL Handles Connections
SQL Net Version 1
SQL Net Enhancements
Distributed DB Connectivity
Networking Conclusion
Net Services Architecture
Net Parameter Files
Network Component Tools
Components Functions tnsnames.ora
protocol.ora File
TCP.NODELAY option
sqlnet.ora File Location
Sqlnet ora File Characteristics
Net Communications Process Level
Create Oracle DBlink
Database Link Connection
SQLnet Architecture Conclusion
ServerSide Configuration
sqlnet Client/Server Components
Listener Manages Oracle Connection
Configuring Oracle Listener
Oracle Net Assistant
Net Assistant Naming Methods
Route Client connection Requests
Set TNS Timeout Value
Setting Listener Password
lsnrctl Listener control Utility
Start listener using lsnrctl
Stop Listener via lsnrctl
Setting Up Protocol Listeners
Client side Configuration
Windows Client Architecture
NET Configuration Assistant
Running Oracle Installer
Oracle Listener Concepts - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following are valid types of listener?
Please select all the correct answers.
A.
A listener that is polling three addresses for three different protocols
B.
A listener that passes requests to a multi-threaded dispatcher
C.
A listener that makes a direct connection to the Oracle database
D.
A listener that allows SNMP connections from a mainframe
2.
Which of the following commands is used to start a SQL*Net version 1 listener?
Please select the best answer.
A.
tcpctl start
B.
tcpctl start listener
C.
lsnrctl start
D.
Lsnrctl start listener
3.
What is the main disadvantage to using Oracle Net Assistant?
Please select the best answer.
A.
It is not practical for large Oracle networks because manually created parameter files cannot always be processed.
B.
It is easier to edit the parameter files manually.
C.
The Oracle Net Assistant does not have the flexibility to allow manual editing.
D.
The Oracle Net Assistant wizards are not very intuitive.
4.
If you have very high connection volumes, what is the best approach to configuring the listener?
Please select the best answer.
A.
Create multiple listeners on the server.
B.
Create a multi-protocol listener.
C.
Create the listener with additional service handlers.
D.
Create a multi-threaded server for each database.
5.
Which of the following commands is used to see the available listener control commands?
Please select the best answer.
A.
lsnrctl help
B.
lsnrctl syntax
C.
tcpctl help
D.
lsnrctl ?
6.
Which of the following statements about the Oracle Net listener is not true?
Please select the best answer.
A.
The listener contains an entry for each database on the host.
B.
The listener process will start automatically when the database is started.
C.
The listener runs as an independent process on the server.
D.
The listener can be "bounced" without affecting existing connections.
7.
Which of the following statements about Oracle Net multi-protocol support is not true?
Please select the best answer.
A.
Multi-protocol support requires defining a multi-threaded server for each database.
B.
Oracle Net protocols are defined in the listener.ora file.
C.
The Oracle Net Connection Manager can be used in lieu of multi-protocols in the listener.ora file.
D.
The Oracle Net listener can support protocols from PCs, mainframes, and virtually every type of remote protocol.