A. loss of one of the tablespaces
B. loss of a system data file
C. loss of one of the control files
D. loss of a tempfile
E. loss of the only member of an unarchived redo log group
F. loss of a member from each redo log group

A. a list of all those files that have been deleted in the last two days
B. a list of all those files that have been recovered within the last two days
C. a list of all the expired backups and copies
D. a list of backups and copies that are outside the range covered by the current retention policy

A. RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
B. RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
C. RMAN would relocate all the database files to an ASM disk group.
D. RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

A. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
B. You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
C. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
D. You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

A. log writer
B. archival
C. process monitor
D. system monitor
E. change tracking writer
F. database writer

A. take data files from the read-only tablespace offline before performing a recovery
B. recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
C. drop the read-only tablespace and re-create the tablespace after recovery
D. perform a recovery； status of the tablespace in control file will be changed automatically

A. activate the Pending Area before creating the consumer group
B. create the Pending Area before creating the consumer group
C. increase the size of the database buffer cache to accommodate the Pending Area
D. increase the size of the shared pool to accommodate the Pending Area
E. increase the size of the large pool to accommodate the Pending Area

A. FREQ = MONTHLY； BYDAY = 2FRI；
B. FREQ = MONTHLY； BYDAY = FRI（2）；
C. FREQ = MONTHLY； BYDAY = FRI2；
D. FREQ = MONTHLY； BYDAY = -2FRI；

A. A total of 14 GB memory will be allocated to the automatically tuned memory components
B. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
C. The value for SGA_TARGET can be increased up to a maximum of 14 GB
D. A maximum of 3 GB can be allocated to shared pool
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F. Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

A. use DBMS_IJOB package
B. use Oracle Scheduler
C. use DBMS_JOB package
D. use Oracle Data Pump Export and Import

A. The database allows only queries； no other statements are allowed.
B. The database re-creates the missing redo log files automatically.
C. The database continues to function normally with the existing files.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.