Oracle Interview FAQ's.

1. Explain about Oracle Catalog and  Archive log? 

           The Oracle  catalog contains tables and views which allows the oracle user to obtain the information about  database, such as what other tables and views are available, data dictionary views their attributes, constraints, etc. Oracle has hundreds of  system catalog relations, only some of which are available to the limited user.
  

     2. Give some of the  views in RMAN catalog which contains the catalog information?

           RC_DATABASE_INCARNATION

           RC_BACKUP-DATAFILE_SUMMARY

           RC_BACKUP_CORRUPTION 

           RC_BACKUP_COPY_DETAILS


3. How to find alert log file location?
   
SQL> show parameter background

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      c:\app\user\diag\rdbms\rev\rev\trace