a2zinterviews

61.	What Oracle object is used for recovery operations?
	The redo log files and the archieve log files are used for database recovery.
	Discuss 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.
	Discuss 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.
	Discuss 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.
	Discuss 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.
	Discuss Your Name Your Email-ID Your Answer