Online Access Free 1Z0-025 Exam Questions

The steps required to recover a tablespace with recovery manager are listed below.
Place them in correct order.
Steps to recover a tablespace, provide proper order

• A.Run RMAN to restore/recover.
• B.Check status of the database.
• C.Check on recovery completion.
• D.List data files that need to be restored.
• E.Take a backup.

Which statement about 'cancel-based recovery' is true?

• A.Recovery is stopped when the database has committed all changes up to the specified system change number (SCN).
• B.Recovery is stopped after the database has committed all changes up to the specified point-in-time.
• C.Recovery is stopped when the specified method of recovery (CANCEL, TIME, or CHNAGE) is completed, and the control files are recovered.
• D.Recovery is stopped by entering CANCEL at the recovery prompt.
• E.Recovery is stopped by pressing at <CTL-C> the recovery prompt.

You have determined that one of the data files belonging to the SYSTEM tablespace is corrupt. Which complete media recovery scenario do you choose?

• A.Complete recovery - opened database, initially closed.
• B.You cannot recover from the corruption of a database file belonging to the SYSTEM tablespace except by going back to the last full backup.
• C.Complete recovery - mounted database.
• D.Complete recovery - opened database, initially opened.

Your recovery catalog user account is RECMAN with a password of RECMAN. Which command will connect to Recovery Manager through the user SMITH with a password DANGER if the database containing the recovery catalog is identified by the TNS alias RCVCAT?

• A.$ target smith/danger rcvcat recman/recman@RCVCAT
• B.$ rman rcvcat recman/recman@RCVCAT target (smith/danger)
• C.$ rman smith/danger rcvcat recman/recman@RCVCAT
• D.$ rman target smith/danger rcvcat recman/recman@RCVCAT

When configuring a database in ARCHIVELOG mode and enabling automatic archiving, the database must be shut down and opened in the MOUNT stage. Which three options can be used to do this? (Choose three)

• A.SHUTDOWN ABORT AND STARTUP MOUNT
• B.SHUTDOWN IMMEDIATE AND STARTUP MOUNT
• C.STARTUP FORCE MOUNT
• D.STARTUP TRANSACTIONAL MOUNT
• E.SHUTDOWN TRANSACTIONAL AND STARTUP MOUNT
• F.SHUTDOWN NORMAL AND STARTUP MOUNT
• G.SHUTDOWN IMMEDIATE AND STARTUP