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 TNS Names - Quiz
Each question is worth one point. Select the best answer for each question.
1.
The tnsnames.ora file is best described as
Please select the best answer.
A.
A process that listens for incoming database connections
B.
A file that is used to supply host, protocol, and database information for incoming requests
C.
A file that is used to hide the details about what is needed to connect to a remote database
D.
Total Network Support
2.
If you were exploring a new Net8 computer and you did not know if it was configured as an Oracle server, what file would you look for?
Please select the best answer.
A.
tnsnames.ora
B.
sqlnet.ora
C.
listener.ora
D.
protocol.ora
3.
Which of the following best describes a database link?
Please select the best answer.
A.
A software component that assists in establishing connectivity with remote servers
B.
An internal Oracle component that adds a USER ID and password to a TNS service name
C.
A component that makes the physical connections to the Oracle database, establishing a server process
D.
A tool to define the Net8 environmental files
4.
The main shortcoming of SQL*Net version 1 is that
Please select the best answer.
A.
It does not have the ability to establish communications between multiple protocols.
B.
It does not possess a listener process.
C.
It does not have the ability to use connect strings.
D.
It is a legacy technology.
5.
Which of the following components is not used by the Oracle listener?
Please select the best answer.
A.
listener.ora
B.
tnsnames.ora
C.
database link information
D.
dispatcher process
Correct answers:
Your Score: 0
Submit
Quiz Explanation