RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
Oracle Network Topology
Oracle Certification
Overview Oracle Networking
SQL*Net Architecture
SQLNet ServerSide Configuration
Oracle TNS- Quiz
Each question is worth one point. Select the best answer or answer for each question.
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
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
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
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
