What is Dirty Read ?

Add comment

Votes: 0

Comments: 0

A dirty read occurs when two operations say, read and write occurs together giving the incorrect or unedited data. Suppose, A has changed a row, but has not committed the changes. B reads the uncommitted data but his view of the data may be wrong so that is Dirty Read.

Others in this Category

	Q: Emp table had an employee with salary 2000. I issued an update statement to set the salary to 3000. Then I issued a create table statement. However the create table command errored out. I want to rollback the earlier update statement. Can I do that?
	Q: What is CYCLE/NO CYCLE in a Sequence ?
	What is sub-query? Explain properties of sub-query?
	What is Filtered Index?
	What are the different index configurations a table can have?
	What are the properties and different Types of Sub-Queries?
	What is Filestream?
	Q: What is ON DELETE CASCADE ?
	What are the difference between clustered and a non-clustered index?
	What is CLR?
	» More articles