A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB. ALTER ……

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

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