Oracle 1Z0-025 Actual Tests : Backup and Recovery

Oracle 1Z0-025 Exam Syllabus Topics:

Oracle Backup and Recovery Sample Questions:

1. Your database is in ARCHIVELOG mode, and you want to recover from a media failure taken up to the time of failure. Which files do you need to restore?

A) The damaged files from a backup taken after the database was set in ARCHIVELOG mode.
B) The damaged files, the redo-log files, and the control files from a backup taken after the database was set in ARCHIVELOG mode.
C) The damaged files and the redo log files from a backup taken after the database was set in ARCHIVELOG mode.
D) The damaged files from any valid backup.

2. Which statement regarding recovery manager with a database operating in NOARCHIVELOG mode is true?

A) Recovery manager is compatible with enterprise backup utility.
B) Recovery manager only works in conjunction with a tape subsystem.
C) Recovery manager supports multi-level incremental backups.
D) Recover manager requires a recovery catalog.

3. Which statement regarding the allocation of processes to recovery manager is true?

A) Enabling I/O slaves can be controlled by setting USE_IO/SLAVES appropriately.
B) I/O slaves can only be used if the operating system supports asynchronous I/O.
C) Setting BACKUP_TAPE_IO_SLAVES=TRUE will enable a dedicated slave to write to a tape device.
D) When enabling I/O slaves, ensure that the shared pool is sized appropriately.

4. Which RECOVER command is appropriate when, while recovering a lost data file, a DBA discovers that a required, archived redo-log is corrupted?

A) RECOVER DATABASE USING BACKUP CONTROLFILE;
B) ALTER TABLESPACE system RECOVER;
C) RECOVER DATABASE UNTIL CANCEL;
D) RECOVER TABLESPACE system UNTIL CANCEL;
E) RECOVER DATABASE UNTIL MISSING REDOLOG;

5. Which two types of data files can be considered non-essential? (Choose two)

A) Data files belonging to a temporary tablespace.
B) Data files belonging to a lost tablespace.
C) Data files belonging to a rollback segment tablespace.
D) Data files belonging to a SYSTEM tablespace.
E) Data files belonging to an index tablespace.
F) Data files belonging to an application data tablespace.

Solutions: