RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Managing Users
«Prev
Next»
User Connectivity
Configuring Oracle
SID List Listener
Configuring Listener
Oracle Net Basic Concepts
Password Files
Necessary Password Files
Password Creation Process
Placing | Naming PW File
Creating Password File
Remote Login Password
Connecting Internal Password
DBA Privileges
Different DBA Roles
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
SQL Plus Worksheet
OEM Architecture
SQL* Plus CLI
Accept Prompt Commands
Spooling Printing Report
SQL Plus Line Editing Commands
Creating Users
Steps To Change Security Manager
Default Tablespaces
Drop User
What Objects does User Own
Managing User Roles
Types System Privileges
Granting System Privileges
With Admin Option Clause
session_privs View
Revoke Privileges Oracle
Managing System Privileges
Oracle Net Client Configuration - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
You tnsping the
COIN
instance, and you get a "Failed to resolve name" message in response. Your tnsnames.ora file contains an entry for
"COIN.WORLD"
. What is the likely reason that your tnsping failed?
Please select the best answer.
A.
The
NAMES.DEFAULT_DOMAIN
parameter in your sqlnet.ora file is set to something other than
\WORLD\
.
B.
You cannot use punctuation in a service name, so "
COIN.WORLD
" is syntactically incorrect.
C.
You did not connect to the server named
WORLD
when logged into the LAN.
D.
The remote listener does not contain an entry for the
WORLD
domain.
2.
What exactly does a successful execution of the ping command indicate?
Please select the best answer.
A.
The remote host can be contacted over the network.
B.
The remote listener can be contacted over the network.
C.
The database is up and running, and responding to queries.
D.
The listener can communicate with the database.
3.
What exactly does a successful execution of the tnsping command indicate?
Please select the best answer.
A.
The remote host can be contacted over the network.
B.
The remote listener can be contacted over the network.
C.
The database is up and running, and responding to queries.
D.
The listener can communicate with the database.
4.
What three pieces of information do you need to create a tnsnames.ora entry for a database instance on a TCP/IP network?
Please select all the correct answers.
A.
The instance name, or SID
B.
The password for the internal user
C.
The name or TCP/IP address of the host
D.
The port number on which the listener is listening