单选题The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following co

题目
单选题
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl What could be the reason for this?（）
A

The listener is not running on the database node.

B

The TNS_ADMIN environment variable is set to the wrong value.

C

The orcl.oracle.com database service is not registered with the listener.

D

The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

E

The listener is running on a different port.

相似考题

1.You executed the following command:RMAN> RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails

2.The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL >CONNECT scott/tiger@orcl What could be the reason for this?（）A. The listener is not running on the database node.B. The TNS_ADMIN environment variable is set to the wrong value.C. The orcl.oracle.com database service is not registered with the listener.D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E. The listener is running on a different port.

3. Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. A、 rman target=/ catalog=/@rcatB、 rman target=/ catalog=rcat_own/rcat_ownC、 rman target=/ catalog=rcat_own/rcat_own@RCATD、 rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCATE、 You cannot connect to the target database and the recovery catalog at the same time.

4.View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following co”相关问题

  • 第1题：

    You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command：        ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   You erroneously deleted the password file while the database was running. You re-create the password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4   However， when you try to connect as the SYS user， you receive the following error：        ORA-01031： insufficient privileges   What should you do to resolve this error？（）

    • A、 Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.
    • B、 Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.
    • C、 Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.
    • D、 Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.

    正确答案:D

  • 第2题：

    Your tnsnames.ora file has the following entry for the service alias ORCL：  ORCL =  （DESCRIPTION =  （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521））   （CONNECT_DATA =  （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com）   ）   ）   The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command：  SQL> CONNECT scott/tiger@orcl  What could be the reason for this？（）

    • A、The listener is not running at the server.
    • B、The TNS_ADMIN environmental variable is set to a wrong value.
    • C、The orcl.oracle.com database service is not registered with the listener.
    • D、The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.

    正确答案:C

  • 第3题：

    You executed the following command：   RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’；   Which statement regarding the above command is correct？（）  

    • A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.
    • B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.
    • C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.
    • D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

    正确答案:C

  • 第4题：

    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve by the above process（）

    • A、The database user OPS$SKD will be able to administer the database.
    • B、The authentication detail for the database user OPS$SKD is recorded in the password file.
    • C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.
    • D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.

    正确答案:C

  • 第5题：

    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

  • 第6题：

    You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command：   LSNRCTL>STATUS listener1   Which information will NOT be displayed when you issue the above command？（） 

    • A、 whether the password is set in the listener or a file or not
    • B、 the number of client connections the service handler has refused
    • C、 the information will be displayed whether the instance can accept connections or not
    • D、 the protocol addresses on which the listener is configured to listen

    正确答案:B

  • 第7题：

    单选题
    What could be the reason for this（）
    A

    The listener is not running on the database node.

    B

    The TNS_ADMIN environmental variable is set to a wrong value.

    C

    The orcl.oracle.com database service is not registered with the listener.

    D

    The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    Your tnsnames.ora file has the following entry for the service alias ORCL：  ORCL =  （DESCRIPTION =  （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521））   （CONNECT_DATA =  （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com）   ）   ）   The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command：  SQL> CONNECT scott/tiger@orcl  What could be the reason for this？（）
    A

    The listener is not running at the server.

    B

    The TNS_ADMIN environmental variable is set to a wrong value.

    C

    The orcl.oracle.com database service is not registered with the listener.

    D

    The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.


    正确答案： C
    解析： 暂无解析

  • 第9题：

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


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command：        ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   You erroneously deleted the password file while the database was running. You re-create the password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4   However， when you try to connect as the SYS user， you receive the following error：        ORA-01031： insufficient privileges   What should you do to resolve this error？（）
    A

     Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.

    B

     Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.

    C

     Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.

    D

     Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）
    A

    The database user OPS$SKD will be able to administer the database.

    B

    The authentication detail for the database user OPS$SKD is recorded in the password file.

    C

    The local operating system user SKD will be able to access the database instance without specifying the username and password.

    D

    The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）
    A

    The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy

    B

    The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup

    C

      Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf

    D

    Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails


    正确答案： B
    解析： 暂无解析

  • 第13题：

    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）

    • A、The database user OPS$SKD will be able to administer the database.
    • B、The authentication detail for the database user OPS$SKD is recorded in the password file.
    • C、The local operating system user SKD will be able to access the database instance without specifying the username and password.
    • D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

    正确答案:C

  • 第14题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第15题：

    You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）

    • A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
    • B、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
    • C、  Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
    • D、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails

    正确答案:C

  • 第16题：

    The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl What could be the reason for this?（）

    • A、The listener is not running on the database node.
    • B、The TNS_ADMIN environment variable is set to the wrong value.
    • C、The orcl.oracle.com database service is not registered with the listener.
    • D、The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
    • E、The listener is running on a different port.

    正确答案:C

  • 第17题：

    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

  • 第18题：

    You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error.   SQL> startup ORACLE instance started.  Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.  ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1：  ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log   What steps must you take to resolve the error？（） a. Issue the recover database redo logs command.  b. Issue the Startup Mount command to mount the database.  c. Restore the last full database backup.  d. Perform a point-in-time recovery， applying all archived redo logs that are available.  e. Restore all archived redo logs generated during and after the last full database backup.  f. Open the database using the alter database open resetlogs command.  g. Issue the alter database open command.

    • A、b， a， f
    • B、e， b， a， f
    • C、e， b， a， g
    • D、b， a， g
    • E、c， e， b， d， f

    正确答案:E

  • 第19题：

    多选题
    Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database.
    A

    rman target=/ catalog=/@rcat

    B

    rman target=/ catalog=rcat_own/rcat_own

    C

    rman target=/ catalog=rcat_own/rcat_own@RCAT

    D

    rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT

    E

    You cannot connect to the target database and the recovery catalog at the same time.


    正确答案： C,A
    解析： 暂无解析

  • 第20题：

    单选题
    You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command：   LSNRCTL>STATUS listener1   Which information will NOT be displayed when you issue the above command？（）
    A

     whether the password is set in the listener or a file or not

    B

     the number of client connections the service handler has refused

    C

     the information will be displayed whether the instance can accept connections or not

    D

     the protocol addresses on which the listener is configured to listen


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve by the above process（）
    A

    The database user OPS$SKD will be able to administer the database.

    B

    The authentication detail for the database user OPS$SKD is recorded in the password file.

    C

    The local operating system user SKD will be able to access the database instance without specifying theusername and password.

    D

    The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    You executed the following command：   RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’；   Which statement regarding the above command is correct？（）
    A

     The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.

    B

     The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.

    C

     Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.

    D

     Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error.   SQL> startup ORACLE instance started.  Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.  ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1：  ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log   What steps must you take to resolve the error？（） a. Issue the recover database redo logs command.  b. Issue the Startup Mount command to mount the database.  c. Restore the last full database backup.  d. Perform a point-in-time recovery， applying all archived redo logs that are available.  e. Restore all archived redo logs generated during and after the last full database backup.  f. Open the database using the alter database open resetlogs command.  g. Issue the alter database open command.
    A

    b， a， f

    B

    e， b， a， f

    C

    e， b， a， g

    D

    b， a， g

    E

    c， e， b， d， f


    正确答案： C
    解析： 暂无解析

相关内容