B. Server-managed recovery is another name for RMAN recovery because the server session performs the recovery process as it interacts with the target database.

C. The control file autobackup is enabled by setting parameters within RMAN by using CONFIGURE CONTROLFILE AUTOBACKUP ON.

C. The database needs to be started in NOMOUNT mode because there is not a control file available to MOUNT the database. Next, the control file can be restored. Once a restored control file is available, the database can be started in MOUNT mode so that standard database recovery can continue. When recovery is complete, the database can OPEN for normal use.

A, C. The target database is not identifiable by database name without the control file. So you must first use the CONNECT TARGET / command to connect. The target database needs to be identified by the database identifier (DBID) number with the command SET DBID database identifier. This database identifier number denotes the target database. When you are recovering the control file, the target database identification is not available because it is stored in the control file.

C. The database must be mounted before the RECOVER command can be executed. You first must restore control so you can MOUNT the database.

A, B. The ALTER DATABASE BACKUP CONTROL FILE TO TRACE command creates a user trace file, which stores an ASCII representation of the binary control file.

B, C. The two cases in the backup control file are opening the database with RESETLOGS or NORESETLOGS.

A, B. The server file, SPFILE or PFILE must be available to start the database with the right parameters, and the datafiles must be in the location matching the control file. The redo logs and control file will be rebuilt.

A, C. Incomplete recovery is a recovery that stops before the failure and a recovery that is missing transactions. Incomplete recovery is not complete or missing some data that was previously stored in the database prior to the failure.

D. The proper process of performing a RMAN based incomplete recovery utilizing a time stamp to determine the point-in-time to complete the recovery process is as follows: Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable if not present, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN RESETLOGS command.

A. The SET UNTIL CHANGE command is not used with RMAN. This command is used during a user-managed incomplete recovery.

A, B, C. Incomplete recovery is designed to be able to stop at a desired point, before introducing undesired transactions to the database.

B. The UNTIL TIME clause is available in both user-managed and RMAN-based incomplete recovery methods.

D. The UNTIL CANCEL command is available only in user-managed recovery. This command allows you to stop the recovery process at a random point during redo log switches.

A. The ALTER DATABASE OPEN RESETLOGS command is required with every incomplete recovery. This is because the redo log sequence always needs to be reset.

C. When using EM, the database must be shut down and started in MOUNT mode so that a whole database backup can be performed when you are recovering the same database EM is connected to.

A, B, C. You need two credentials when running a recovery with EM: the correct operating system account and the correct database account. The correct operating system account is an account similar to the Oracle account in Unix or the administrator account in Windows. The database account is any account that has SYSDBA privilege.

D. The RESETLOGS clause is required with all incomplete recovery options. The RESETLOGS clause is required because you are opening the database to a point prior to the existing redo log entries. So the redo logs must be reset when the database is opened.

B. You need to know the redo log sequence number and thread to perform an UNTIL SEQUENCE recovery in RMAN. This can be obtained by querying the V$LOG_HISTORY dynamic view.

D. The new feature to recover your database through a prior RESETLOGS recovery is native with Oracle 10g. Oracle will recover the database through the RESETLOGS prior to recovery if necessary.