Oracle Backup and Recovery - 1Z0-025 Free Exam Questions

A. A user that owns the RMAN catalog.

B. User SYSDB

C. A user with SYSDBA privilege.

D. User SYSTEM.

A. The database must be available in ARCHIVELOG mode.

B. An operating system backup of the database files is required.

C. All the database files copied are consistent to a point-in-time.

D. The database is available for use during backups.

A. Recovery manager cannot be used with a database running in NOARCHIVELOG mode.

B. For full recovery of a database not in NOARCHIVELOG mode using recovery manager, a current recovery catalog in mandatory.

C. The target database must be in MOUNT mode for restriction of data files.

D. To restore to a previous point in time using recovery manager, the command PARTIAL RECOVER must be included in the RMAN script.

E. A DBA can only restore using RMAN if the backups were taken or registered with recovery manager.

A. The standby database can only be used in read-only mode.

B. It invalidates the standby database.

C. A new standby database incarnation will automatically be started.

D. Once the archived log files are applied to the standby database, the redo log of the standby database is reset.

A. UNCATALOG

B. DELETE

C. REMOVE

D. CATALOG REMOVE

A. Take the data files that you need to restore offline.

B. Issue the switch command.

C. Copy the data files to the new location using an operating system tool.

D. Issue the restore command.

A. When ARCHIVE_LOG_START needs to be changed.

B. When the name of the recovery catalog file needs to be changed.

C. When all archived redo-log files are lost.

D. When MAXLOGMEMBERS needs to be changed.

A. Create and recover the database on another machine and use the transportable tablespace option.

B. Create and recover a clone database and export the primary database into this new database.

C. Create and recover a clone database, export the table from the clone database, then import it into the primary database.

D. Recover only the files for the tablespace that contains the ORDER table.

A. You can maintain records of backup and recovery operations.

B. You can register the target database with recovery catalog.

C. You can store scripts for backup and recovery operations.

D. You can copy the redo-log history into the control file.

E. You can synchronize the recovery catalog and the target database.

A. The size of archived log files.

B. How frequently log files will be archived.

C. That the database is in ARCHIVELOG mode.

D. Whether archiving will be manual or automatic.