Oracle认证考试
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？（）A、Local NamingB、Easy ConnectC、External NamingD
题目
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？（）
- A、Local Naming
- B、Easy Connect
- C、External Naming
- D、Directory Naming
相似问题和答案
第1题：
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）
- A、Host naming method
- B、Local naming method
- C、External naming method
- D、Directory naming method
正确答案:B
第2题：
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）
- A、More than one database is to be registered with the listener.
- B、The users will connect the database by using the host naming method.
- C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
- D、The database that is to be registered with the listener is configured in shared server mode.
- E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
正确答案:C,E
第3题：
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?（）
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
第4题：
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？（）
- A、snmp.ora
- B、names.ora
- C、spfile.ora
- D、sqlnet.ora
- E、listener.ora
- F、tnsnames.ora
正确答案:D,F
第5题：
In which situation would you use static database registration for a listener（）
- A、when multiple databases are to be registered with the listener
- B、when DBAs need to connect remotely to start up the database instance
- C、when users need to connect the database instance using the host naming method
- D、when the database instance that is to be registered with the listener is configured in shared server mode
正确答案:B
第6题：
You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb Which three statements are correct regarding the connection string？（）
- A、mydb is a service name.
- B、test.us.oracle.com is a database name.
- C、1521 is the listener port number.
- D、mydb is a host name.
- E、test.us.oracle.com is a net service name.
- F、hr is a username.
- G、test.us.oracle.com is an instance name.
正确答案:A,C,F
第7题：
You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks. To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 After creating the password file， you remove the operating system authentication and change the value of the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）
- A、 CONNECT / AS SYSDBA
- B、 CONNECT sys/admin AS SYSDBA
- C、 CONNECT sys/admin@mynewdb AS SYSDBA
- D、 CONNECT sys/change_on_install AS SYSDBA
正确答案:D
第8题：
You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP address and listener port number， change frequently due to development requirements， and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）
- A、Host naming
- B、Local naming
- C、Easy Connect
- D、External naming
- E、directory naming
正确答案:E
第9题：
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？（）
- A、tnsnames.ora must be on the client machine for local naming.
- B、tnsnames.ora must be removed from the server for the connection to work.
- C、tnsnames.ora must be on both the client and server machines for local naming.
- D、tnsnames.ora is not required for local naming; the problem was not fixed by copying the file to the client.
正确答案:A
第10题：
Connection Manager features cannot be used with which of the following naming method？ （）
- A、Oracle names
- B、Local Naming
- C、Host Naming
- D、Names Server
正确答案:C