Free Oracle 1Z0-025 Exam Dumps Questions & Answers

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.  RECOVER DATABASE UNTIL MISSING REDOLOG;
• C.  RECOVER TABLESPACE system UNTIL CANCEL;
• D.  ALTER TABLESPACE system RECOVER;
• E.  RECOVER DATABASE UNTIL CANCEL;

What are two causes of media failures? (Choose two)

• A.  The user issues an abnormal interrupt.
• B.  There is a logic error in the application.
• C.  The server computer loses power.
• D.  A table is accidentally truncated.
• E.  A database file is accidentally deleted.
• F.  There is a head crash on the disk containing a database file.

Given the RMAN script:
run(
allocation channel t2 type 'SET_TAPE'
backup filesperset 3
format '/disk1/backup/ar_%t_%s_%p'
(Archivelog from logseq*1056 until logseq*1056
thread*1 delete input):
)
What does this script do?

• A.  Backup three archived logs into one backup set.
• B.  Backup three archived logs into three backup pieces.
• C.  Backup one data file into one backup set.
• D.  Backup one archived log into one backup piece.
• E.  Backup one archived log into three backup set.
• F.  Backup three data files into one backup set.

Work is done by recovery manager through ____?

• A.  Operating system scripts.
• B.  Operating system commands.
• C.  External procedures.
• D.  PL/SQL packages.

Which statement about an open database backup is NOT true?

• A.  An operating system backup of the database files is required.
• B.  The database is available for use during backups.
• C.  All the database files copied are consistent to a point-in-time.
• D.  The database must be available in ARCHIVELOG mode.