Examine the following scenario:✑ Database is running in ARCHIVELOG mode.✑ Complete consistent backup is taken every Sunday.✑ On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.✑ The hardware is repaired and the paths for online redo log files and control files are still valid.Which option would you use to perform the recovery of database till the point of failure?
You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:SQL> SELECT object_name, original_name, droptime FROM recyclebin;What would be the outcome of the precedent statement?
Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.You decide to perform an incomplete recovery using the following command:SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00';Identify the files that must be restored to recover the missing tables successfully.
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)
Your database is open and running in ARCHIVELOG mode.You take RMAN full backups every Sunday night.On Monday morning, while querying the user1.emoloyees table, you receive the following error message:01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5: '/u01/app/oracle/oradata/orcl/exanple0l.dbf*You need to recover from this while ensuring that:1. The data file remains online.2. Mean Time To Recover (MTTR) is minimized as much as possibleYou have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements?
Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?
