Local Naming
Easy Connect
External Naming
Directory Naming
第1题:
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this?()
第2题:
You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?()
第3题:
You are connecting to an Oracle database server from a client by using the following connect string: SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb Which naming method is being used in this case?()
第4题:
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?()
第5题:
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine()
第6题:
You work as a database administrator for Supportcenter.cn. You are using three database, SupportCenter DB01, SupportCenter DB02, and SupportCenter DB03, on different host machines in your development environment. The database server configuration, such as IP address and listener port number, change frequently due to development requirements, and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead?()
第7题:
host naming method
local naming method
directory naming method
external naming method
第8题:
tnsnames.ora must be on the client machine for local naming.
tnsnames.ora must be removed from the server for the connection to work.
tnsnames.ora must be on both the client and server machines for local naming.
tnsnames.ora is not required for local naming; the problem was not fixed by copying the file to the client.
第9题:
Host naming method
Local naming method
External naming method
Directory naming method
第10题:
host naming method
local naming method
external naming method
directory naming method
第11题:
mydb is a service name.
test.us.oracle.com is a database name.
1521 is the listener port number.
mydb is a host name.
test.us.oracle.com is a net service name.
hr is a username.
test.us.oracle.com is an instance name.
第12题:
when multiple databases are to be registered with the listener
when DBAs need to connect remotely to start up the database instance
when users need to connect the database instance using the host naming method
when the database instance that is to be registered with the listener is configured in shared server mode
第13题:
A client/server application has been configured to use local naming. The client and server run on separate machines. When the client tries to connect, it receives a TNS error. By carefully examining the environment, a tnsnames.ora is found only on the Oracle server machine, among other things. After copying this tnsnames.ora onto the client machine, the client is able to connect to the server. Which statement is true?()
第14题:
Connection Manager features cannot be used with which of the following naming method? ()
第15题:
The three tasks shown have been completed in order to configure a naming method: Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor Task 2: Started default listener on port 1521 Task 3: Added global database name to the listener.ora file. Which naming method was configured?()
第16题:
Click the Exhibit button and examine the diagram. You are running a database that takes advantage of features provided by Connection Manager, heterogeneous services, and external procedures. The diagram depicts the components used for the naming method you just configured. Which naming method are you using?()
第17题:
Your database is not configured for session failover. Your tnsnames.ora file contains the following details: test.us.oracle.com= (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=off) (FAILOVER=ON) (ADDRESS= (PROTOCOL=tcp)(HOST=test1-server)(PORT=1521)) (ADDRESS= (PROTOCOL=tcp)(HOST=test2-server)(PORT=1521))) (CONNECT_DATA= (SERVICE_NAME=test.us.oracle.com))) Which feature is enabled in this case?()
第18题:
You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most likely cause of the connection issues. What should you do first?()
第19题:
snmp.ora
names.ora
spfile.ora
sqlnet.ora
listener.ora
tnsnames.ora
第20题:
Ensure that port 1433 is open in your firewall.
Ensure that port 443 is open in your firewall.
Ensure that client computers connect by using Shared Memory protocol.
Ensure that the server is not paused.
第21题:
CONNECT / AS SYSDBA
CONNECT sys/admin AS SYSDBA
CONNECT sys/admin@mynewdb AS SYSDBA
CONNECT sys/change_on_install AS SYSDBA
第22题:
Local Naming
Easy Connect
External Naming
Directory Naming
第23题:
More than one database is to be registered with the listener.
The users will connect the database by using the host naming method.
The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
The database that is to be registered with the listener is configured in shared server mode.
The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
第24题:
Host naming method.
Local naming method.
Directory naming method.
External naming method.