a2zinterviews

5.	What is LoGWRiter(LGWR)?
	LGWR is the background process that writes redo information from redo log buffers to the log files.
	Discuss Your Name Your Email-ID Your Answer

6.	What do you mean by data consistency?
	Data consistency provides a stable or consistent data to the users throughout the session. Data consistency is maintained through rollback segments. A rollback statements holds the data image before change; therefore, one or more session will get the same image of the data throughout the session that were reading the data while another session is updating.
	Discuss Your Name Your Email-ID Your Answer

7.	What are the components of SGA?
	SGA is used to store shared information. It includes Buffer cache Log buffer Shared poll Large Pool and Java pool
	Discuss Your Name Your Email-ID Your Answer

8.	What are the components of an Oracle instance?
	Background process and memory structure are the two components of an Oracle instance.
	Discuss Your Name Your Email-ID Your Answer