Online Access Free 1Z0-025 Exam Questions

Which command should you use to issue to find all backup sets containing the data file query1.dbf?

• A.Rman> list backup set of datafile 'query1.dbf';
• B.Rman> creat list of backup set of datafile 'query1.dbf';
• C.Rman> report backup set of datafile 'query1.dbf';
• D.Rman> catalog backup set of datafile 'query1.dbf';

When performing an open database backup, which statement is NOT true?

• A.The database must be operating in ARCHIVELOG mode.
• B.The database can be open but only in READ ONLY mode.
• C.The database tablespaces should be in BEGIN BACKUP mode.
• D.The database is fully accessible to all users.

Which two statements regarding the use of Recovery manager with a database in NOARCHIVELOG mode are true? (Choose two)

• A.For full recovery of a database not in NOARCHIVELOG mode using recovery manager, a current recovery catalog in mandatory.
• B.To restore to a previous point in time using recovery manager, the command PARTIAL RECOVER must be included in the RMAN script.
• C.A DBA can only restore using RMAN if the backups were taken or registered with recovery manager.
• D.Recovery manager cannot be used with a database running in NOARCHIVELOG mode.
• E.The target database must be in MOUNT mode for restriction of data files.

During an opened database backup, a power failure occurs. Which SQL statement do you issue to resolve this situation after mounting the database?

• A.ALTER DATABASE OPEN RESETLOGS
• B.ALTER DATABASE n END BACKUP
• C.ALTER DATABASE DATAFILE n END BACKUP
• D.ALTER TABLESPACE name DATAFILE n END BACKUP

Before executing a script, you decide to switch the current log file. You are already
logged in to recovery manager and want to execute this command from the recovery
manager prompt?
Which command should you use?

• A.Rman> start ('alter system switch logfile'.)
• B.Rman> run ('alter system switch logfile'.)
• C.Rman> execute (sql 'alter system switch logfile'.)
• D.Rman> run (sql 'alter system switch logfile'.)