Oracle Dba Interview Question and Answers

61. What Oracle object is used for recovery operations?
  The redo log files and the archieve log files are used for database recovery.
 
Your Name Your Email-ID
Your Answer
62. Define SGA?
 
  • The SGA is a shared-memory region that Oracle uses to store data and control information for an Oracle instance.
  • The SGA is allocated when the Oracle instance starts and it is de–allocated when the Oracle instance shuts down.
 
Your Name Your Email-ID
Your Answer
63. What is the difference between the conventional path loader and the direct path loader?
  The conventional path loader essentially loads the data using INSERT statements, whereas the direct path loader bypasses much of the logic involved with that and loads directly into the datafiles.
 
Your Name Your Email-ID
Your Answer
64. What is the difference between hot backup and cold backup?
  Hot backup is taken when database is still online while cold backup is taken when database is offline.
Database needs to be in the archive log mode for the hot backup but there is no such requirement for the cold backup.
 
Your Name Your Email-ID
Your Answer
65. What is instance recovery?
  Instance recovery is used in a Real Application cluster (RAC) environment only. It occurs in an open database when one instance detects that another instance has crashed.
 
Your Name Your Email-ID
Your Answer