RelationalDBDesign
SiteMap
Network Config
Network Admin
Network Topology
Network Topology
«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 Net Client - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
If you fail in an attempt to ping a remote server by its host name, what is the best course of action?
Please select the best answer.
A.
Ask a systems administrator to check the services file on your PC.
B.
Try to ping the server using the IP address of the remote computer.
C.
Try using SQL*Plus to connect to the remote server.
D.
Check to see if the listener is running on the remote server.
2.
Which of the following statements is true?
Please select the best answer.
A.
It is possible to connect to an Oracle8 database with Oracle7 client software.
B.
It is always a good idea to use a shared tnsnames.ora file on a networked disk.
C.
The best way to test a TNS problem is with the ping utility.
D.
You should always install the Oracle Net Services Assistant on a PC Oracle client.
3.
Which of the following are valid methods of propagating a tnsnames.ora file to a group of Windows clients?
Please select all the correct answers.
A.
Use a third-party software package to distribute the file.
B.
Send all users an email with the file whenever it changes.
C.
Share the tnsnames.ora file on a PC network disk.
D.
Ask all end users to edit their own tnsnames.ora file on their Oracle8 clients.
4.
Which of the following files will never appear in the /network/admin directory of a Windows client?
Please select the best answer.
A.
listener.ora
B.
topology.ora
C.
sqlnet.ora
D.
tnsnames.ora
5.
SQL*Net Easy will not
Please select the best answer.
A.
Perform a test of the connectivity at the end of the session
B.
Interrogate the server to get the proper port number
C.
Allow you to provide a service name that is different from the database name
D.
Allow you to scroll back if you make a mistake
6.
Who is the best person to install Oracle Net Services clients on thousands of Windows computers?
Please select the best answer.
A.
The Oracle DBA
B.
A non-Oracle technician
C.
A systems administrator
D.
The LAN administrator