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
sqlnet.ora-log
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 Components - Quiz
Each question is worth one point. Select the best answer for each question.
1.
Which of the following statements about the tnsnames.ora file is not true?
Please select the best answer.
A.
The tnsnames.ora file provides the network-specific details about the remote database.
B.
The tnsnames.ora file should use the host name, and not the actual remote server IP address.
C.
The tnsnames.ora file contains everything that is needed to connect to the remote database.
D.
The tnsnames.ora file should include the port number of the remote server.
2.
Which of the following components establishes the connection to the remote database?
Please select the best answer.
A.
The tnsnames.ora file
B.
The database link
C.
The TNS listener
D.
The protocol.ora file
3.
Which of the following is not contained in a database link?
Please select the best answer.
A.
The remote USER ID
B.
The host name of the remote server
C.
The TNS service name
D.
The remote password
4.
Which of the following statements is not true about a Net connection?
Please select the best answer.
A.
The Net client establishes the server process for the request.
B.
The service name is used to perform the look-up in the tnsnames.ora file.
C.
Database links and Net are both required for remote SQL connections.
D.
The protocol.ora file contains cross-protocol information.
5.
Which of the following procedures is not a part of a Net client installation?
Please select the best answer.
A.
Starting the TNS listener process
B.
Installing the Net client software
C.
Configuring the tnsnames.ora file
D.
None of the above
6.
Which of the following characteristics of Net is false?
Please select the best answer.
A.
Resource consumption in Net is greatest for the requesting client processor.
B.
The protocol.ora file enables inter-protocol communications.
C.
The listener process exists only on Oracle servers.
D.
For a distributed query, database links can exist only on the client database.
Correct answers:
Your Score: 0
Submit
Quiz Explanation