网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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

参考答案

更多 “ 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、Directory Naming” 相关考题
考题 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 fileB. authentication by using certificates over SSLC. authentication by using the Oracle Internet DirectoryD. authentication by using the local OS of the database server

考题 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 namingB、Local namingC、Easy ConnectD、External namingE、directory naming

考题 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 methodB、Local naming methodC、External naming methodD、Directory naming method

考题 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.

考题 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.

考题 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 SYSDBAB、 CONNECT sys/admin AS SYSDBAC、 CONNECT sys/admin@mynewdb AS SYSDBAD、 CONNECT sys/change_on_install AS SYSDBA

考题 In which situation would you use static database registration for a listener()A、when multiple databases are to be registered with the listenerB、when DBAs need to connect remotely to start up the database instanceC、when users need to connect the database instance using the host naming methodD、when the database instance that is to be registered with the listener is configured in shared server mode

考题 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.

考题 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.oraB、names.oraC、spfile.oraD、sqlnet.oraE、listener.oraF、tnsnames.ora

考题 Connection Manager features cannot be used with which of the following naming method? ()A、Oracle namesB、Local NamingC、Host NamingD、Names Server

考题 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?()A、host naming methodB、local naming methodC、directory naming methodD、external naming method

考题 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?()A、You can conned as a common user by using the connect statement.B、You can connect as a local user by using the connect statement.C、You can connect by using easy connect.D、You can connect by using OS authentication.E、You can connect by using a Net Service name.F、You can connect as a local user by using the SET CONTAINER statement.

考题 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?()A、Host naming method.B、Local naming method.C、Directory naming method.D、External naming method.

考题 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()A、host naming methodB、local naming methodC、external naming methodD、directory naming method

考题 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?()A、Load balancingB、Instance failoverC、Database failoverD、Connect-time failoverE、Transparent Application Failover (TAF)

考题 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?()A、Host namingB、Local namingC、Easy ConnectD、External namingE、directory naming

考题 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?()A、Ensure that port 1433 is open in your firewall. B、Ensure that port 443 is open in your firewall. C、Ensure that client computers connect by using Shared Memory protocol. D、Ensure that the server is not paused.

考题 单选题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?()A host naming methodB local naming methodC directory naming methodD external naming method

考题 多选题You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. 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?()Asnmp.oraBnames.oraCspfile.oraDsqlnet.oraElistener.oraFtnsnames.ora

考题 单选题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.

考题 单选题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?()A Ensure that port 1433 is open in your firewall.B Ensure that port 443 is open in your firewall.C Ensure that client computers connect by using Shared Memory protocol.D Ensure that the server is not paused.

考题 单选题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 methodB Local naming methodC External naming methodD Directory naming method

考题 单选题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?()A host naming methodB local naming methodC external naming methodD directory naming method

考题 单选题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 Directory Naming

考题 多选题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?()Amydb is a service name.Btest.us.oracle.com is a database name.C1521 is the listener port number.Dmydb is a host name.Etest.us.oracle.com is a net service name.Fhr is a username.Gtest.us.oracle.com is an instance name.

考题 多选题You plan to use static database registration for a new listener when you create it. What could be the two reasons for this?()AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

考题 单选题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?()A Host naming method.B Local naming method.C Directory naming method.D External naming method.