im prepering to ocp backup & recovery
and need help on the foloeing questions
1.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 UNTIL CANCEL;
B. ALTER TABLESPACE system RECOVER;
C. RECOVER TABLESPACE system UNTIL CANCEL;
D. RECOVER DATABASE UNTIL MISSING REDOLOG;
E. RECOVER DATABASE USING BACKUP CONTROLFILE;
2.Before you can restore data files to
a new location using RMAN, what should you do?
A. Issue the switch command.
B. Issue the restore command.
C. Take the data files that you need to restore offline.
D. Copy the data files to the new location using an operating system tool.
3.Which statement regarding Recovery Manager with
a database operating in NOARCHIVELOG mode is true?
A. Recover manager requires a recovery catalog.
B. Recovery Manager supports multi-level incremental backups.
C. Recovery Manager is compatible with enterprise backup utility.
D. Recovery Manager only works in conjunction with a tape subsystem.
4. Why would you set a data file offline when the database is in MOUNT state?
A. To minimize downtime.
B. To allow for automatic data file recovery.
C. To prevent further corruption of a damaged data file.
D. To recover it later, when database is in NOARCHIVELOG mode.
5.Which two benefits does the command ALTER DATABASE MOUNT CLOSE DATABASE
offer for the tablespace point-in-time recovery? (Choose two)
A. It allows the export to recover statistics on the tables.
B. It prevents accidental corruption of the primary database.
C. It allows the SYSTEM tablespace to become a transportable tablespace.
D. It allows the POINT_IN_TIME_RECOVER option on the export to function.
E. It allows you to remove a data file that has been added to the wrong tablespace.
6.With the instance down, how would you recover a lost control file?
A. Use a control file similar database
B. Use the CREATE CONTROLFILE command
C. Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
D. Use the ALTER DATABASE RECOVER CONTROLFILE FROM TRACE command
7.You have been informed that the ORDER table was dropped two days ago.
It is unwise to perform an incomplete recovery of this database;
therefore, your only option is to perform tablespace point-in-time recovery.
What are two ways this can be done in Oracle8i? (Choose two)
A. Recover only the files for the tablespace that contains the ORDER table
B. Create and recover a clone database and export the primary database
into this new database
C. Create and recover the database on another machine
and use the transportable tablespace option
D. Create and recover a clone database,
export the table from the clone database,
then import it into the primary database
8.When two or more databases are backed up using RMAN,
is it appropriate to use each database as the other’s recovery catalog? Why?
A. Yes. The catalog is a recognized procedure
B. No. There would be too many dependencies
C. Yes, but only if the database are run in NOARCHIVELOG mode
D. No. A database that contains a catalog cannot be target database