Oracle Dba Interview Question and Answers

71. What are the components of SGA?
 
    SGA is used to store shared information. It includes
  • Buffer cache
  • Log buffer
  • Shared pool
  • Large pool
  • Java pool.
 
Your Name Your Email-ID
Your Answer
72. What is a synonym?
  A synonym is simply an alias to another object in the database. This object can be a table, view, sequence or program unit.
 
Your Name Your Email-ID
Your Answer
73. What is archive log file?
  Archive log file stores redo log information persistentiy. A redo log is overwritten with time;therefore,archive log maintains that lost information.
 
Your Name Your Email-ID
Your Answer
74. What is a backup set?
  Backup set is a logical grouping of backup files that are created when you issue an RMAN backup command. It is RMAN’s name for a collection of files associated with a backup. A backup set is composed of one or more backup pieces.
 
Your Name Your Email-ID
Your Answer
75. What does database tier consist of?
  Database tier consists of Oracle database, which stores all the data. The database server contains Oracle Home and data files.
 
Your Name Your Email-ID
Your Answer