ASM supports all but which of the following file types? (Choose all that apply.)

A. Database files

B. SPFILEs

C. Redo-log files

D. Archived log files

E. RMAN backup sets

F. Password files

G. init.ora files

Observe the following PL/SQL block:

BEGIN dbms_spm.configure('SPACE_BUDGET_PERCENT', 30); END;

Which statement is correct regarding the above PL/SQL block?

A. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.

B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).

C. It reserves 30% of the space in the SYSTEM tablespace for SMB.

D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:

SQL> SELECT * FROM sales;

Which process would retrieve the result from the database and return it to the client program?

A. User process

B. Server process

C. System Monitor (SMON)

D. Process Monitor (PMON)

E. Checkpoint process (CKPT)

When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.)

A. Tablespace name

B. Storage quota

C. Retention

D. Table name

E. Create a default archive

What are the prerequisites for performing flashback transactions? (Choose all that apply)

A. Supplemental log must be enabled

B. Supplemental log must be enabled for the primary key

C. Undo retention guarantee for the database must be configured

D. "EXECUTE " permission on the DBMS_FLASHBACK package must be granted to the user

View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:

RMAN> BACKUP DATABASE FILESPERSET 2;

The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?

Exhibit:

A. Because the progress is reported for each data file

B. Because the progress is reported for each backup set

C. Because other RMAN sessions have issued the same BACKUP command

D. Because new data files have been added to the database while the RMAN backup is in progress

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

A. It is used to change failure priority only for HIGH or LOW priorities.

B. It is used to execute the advised repair script.

C. It is used to change failure priority only for the CRITICAL priority.

D. It is used to explicitly close the open failures.

E. It is used to inform the database about the repair after the repair script executes.

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN): RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

Identify the statement that correctly describes the implications of this command.

A. when there are already three backups, for the fourth backup RMAN removes the oldest backup.

B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.

C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulative backups.

D. when there are already three backup, one of the existing backups must be removed manually before taking the fourth backup.

Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?

a.

restore controlfile

b.

restore database

c.

restore spfile

d.

recover database

e.

alter database open

f.

alter database open resetlogs

A.

b, a, c, d, e

B.

a, c, b, d, f

C.

c, a, b, d, e

D.

c, a, b, d, f

E.

e, a, b, d, c

Which view provides information on the backup status of the datafiles in the database?

A. V$BACKUP

B. V$BACKUP_STATUS

C. V$BACKUP_DATAFILE

D. V$DATAFILE_BACKUP

E. V$TABLESPCE_BACKUP