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？（）

单项选择题Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?（）

A. a cumulative level 1 backup
B. a differential level 1 backup
C. a full backup
D. a whole backup

单项选择题Which statement about using RMAN stored scripts is true?（）

A. To create and execute an RMAN stored script, you must use a recovery catalog.
B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
D. When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

多项选择题You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)

A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B. A resumable statement is suspended only if an out of space error occurs.
C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D. A resumable statement can only be suspended and resumed once during the execution of the statement.
E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session

单项选择题You executed the following command in the Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）

A. A list of files that require a backup within 3 days
B. A list of files requiring more than 3 days of archivelogs to apply
C. A list of files that RMAN recommends be backed up only once in every three days，based on low volatility
D. A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

单项选择题Which statement about recovering from the loss of a redo log group is true?（）

A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
B. If the lost redo log group is CURRENT, you must clear the log file.
C. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.