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

第2题：

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.

第3题：

第4题：

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.

第5题：

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.

第6题：

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.

第7题：

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.

第8题：

第9题：

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

第10题：

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