RelationalDBDesign
SiteMap
Network Config
Network Admin
Network Topology
Network Topology
«Prev
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
Server Side Configuration
sqlnet Client/Server Components
Listener Manages Oracle Connection
Configuring Oracle Listener
Lsnrctl Listener Ora Interaction
Oracle Net Assistant
Net Assistant Naming Methods
Define Listener TraceLevels
Configure Client Logon Procedure
Route Client Connection Requests
Set TNS Timeout Value
Setting Listener Password
Start listener using lsnrctl
Lsnrctl Help Utility
Start Listener Using Lsnrctl
Stop Listener via lsnrctl
Setting Up Protocol Listeners
TNS Listener Conclusion
Client side Configuration
Windows Client Architecture
NET Configuration Assistant
Running Oracle Installer
Creating Maintaining Tnsnames Ora_file
Managing Tnsnames Ora File Network
Testing OracleNet Connectivity
Sql Client Tools Conclusion
Oracle TNS - Quiz Results
The answers you selected are indicated below, along with text that explains the correct answers.
1.
Which of the following is not a valid way to establish an initial connection to an Oracle database?
Please select the best answer.
A.
With a TNS connect string (
t:host:database
)
B.
With a database link (
select * from customer@ny;
)
C.
With a server connect string (
sqlplus /@fred
)
D.
With a telnet session
The correct answer is D.
Using a telnet session is not a valid way to establish an initial connection to an Oracle database. A telnet session will only establish connections with a server, not the database. A, B, and C are incorrect because using a TNS connect string, a database link, and a server connect string are all valid ways to establish a database connection.
2.
What is the name of the Oracle meta-table used to view database link information?
Please select the best answer.
A.
DBA_TABLES
B.
DBA_DB_LINKS
C.
DBA_SYNONYMS
D.
DBA_2PC_PENDING
The correct answer is B.
The DBA_DB_LINKS meta-table is used to view database link information. A is incorrect because DBA_TABLES views only table information. C is incorrect because DBA_SYNONYMS is used only to view synonyms. D is incorrect because DBA_2PC_PENDING is used only to view two-phase commit transactions.
3.
Which of the following files are used to supply the server IP address?
Please select all the correct answers.
A.
The file /etc/hosts
B.
The file /etc/services
C.
The file tnsnames.ora
D.
The file sqlnet.ora
The correct answers are A and C.
The /etc/hosts file and the tnsnames.ora file are used to supply the server IP address. B is incorrect because /etc/services supplies only port numbers. D is incorrect because sqlnet.ora supplies only Oracle client information.
4.
Which of the following files supplies the protocol information for outgoing Oracle requests?
Please select the best answer.
A.
listener.ora
B.
sqlnet.ora
C.
/etc/hosts
D.
tnsnames.ora
The correct answer is D.
The tnsnames.ora file supplies the protocol information for outgoing Oracle requests. A is incorrect because the listener.ora file is used only for incoming requests. B is incorrect because sqlnet.ora is used only for Net8 clients. C is incorrect because /etc/hosts pairs the host name to the IP address.
Retake - Quiz