单选题Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3

第1题：

A customer has the need to implement a tape backup solution to backup a 500GB database on a daily basis.  Which of the following factors is the most important consideration in the design of a backup and restore solution？（）

• A、Amount of data in the backup
• B、Bandwidth available to the tape device
• C、Length of the backup/restore window
• D、Speed that the backup system can find files for restoration

第2题：

You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

• A、SYSDATE should not be used with TIMESTAMP.
• B、The database must have multiplexed redo log files.
• C、The database must be in the MOUNT state to execute the command.
• D、The database must be opened with the RESETLOGS option after the flashback operation.
• E、The entire database needs to be restored from the most recent backup before the flashback operation.

第3题：

Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database using the RESETLOGS option.  Back up the database.  Case 2：  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3： Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）

• A、only case 1
• B、only case 2
• C、only case 3
• D、case 1 and 2
• E、case 2 and 3
• F、case 1 and 3
• G、all cases： case 1， case 2 and case 3

第4题：

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、 Flash back all the tables in the data file， one by one.
• B、 Restore the data file to a new location and perform a media recovery.
• C、 Flash back the database， there is no need to restore the data file.
• D、 Restore the data file from the most recent backup and flash the database.

第5题：

While planning to manage more than one database in your system， you perform the following activities：  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you？（）

• A、Oracle Managed Files
• B、Oracle Grid Architecture
• C、Optimal Flexible Architecture
• D、Oracle database architecture

第6题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

• A、It must be executed from the Oracle Database 11g environment.
• B、It must be executed only after the SYSAUX tablespace has been created.
• C、It must be executed from the environment of the database that is being upgraded.
• D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

第7题：

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation？（）

• A、recover using Oracle Flashback Database technology
• B、restore the data files from backup and perform a complete recovery
• C、restore only the corrupted data file and perform tablespace recovery
• D、restore the data files from backup and perform cancel-based recovery
• E、restore the entire database from the most recent backup and start the instance and open the database

第8题：

SQ L*Loader is a utility that can perform which two tasks？（）

• A、Load data from a disk， tape， or named pipes.
• B、Load data into an Oracle database using DML statements.
• C、Extract， reorganize， and insert data within an Oracle database.
• D、Load data from external files into tables in an Oracle database.
• E、Load data into an Oracle database using operating system commands.
• F、Load data directly from a non-Oracle database to an Oracle database.

第9题：

You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

• A、The database crashes.
• B、The DBA needs to re-create the file.
• C、The file gets re-created automatically.
• D、The file gets restored automatically from the last backup.
• E、The DBA needs to perform a complete database recovery.
• F、The DBA needs to perform an incomplete database recovery.

第10题：

Case 1：  1. Shut down the database and perform a backup.  2. Restore all the data files.  3. Mount the database.  4. Recover the database.  5. Without applying all the redo log files， open the database using the RESETLOGS option.  6. Back up the database.  Case 2：  1. Shut down the database and perform a backup.  2. Restore only the data files of the tablespace where user error damaged the data.  3. Mount the database. 4. Recover the database.  5. Open the database with the RESETLOGS option.  6. Back up the database.  Case 3：  1. Shut down the database.  2. Restore the data files.  3. Open the database.  4. Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）

• A、 Only case 1
• B、 Only case 2
• C、 Only case 3
• D、 Case 1 and 2
• E、 Case 2 and 3
• F、 Case 1 and 3
• G、 All cases， case 1， case 2， case 3