Anyone please explain me the concept of Serialization?

Answers were Sorted based on User's Feedback

Anyone please explain me the concept of Serialization?..

Answer / monal

Serialization is highest level of Isolation. Most resource
intensive and slowest isolation level. But because of
serialization isolation level all concurrency issues like
dirty read, repeatable read and phantom read won't occur.

Is This Answer Correct ?    1 Yes 0 No

Anyone please explain me the concept of Serialization?..

Answer / anil sharma

Serialization means organise data with relations between
tables.Removing duplicate row maintain structured data.

Is This Answer Correct ?    1 Yes 0 No

Anyone please explain me the concept of Serialization?..

Answer / nixo

Serialization, This is the higest level of Isolation.
When this is on, no dirty reads, no nonrepeatable reads
and no phantom rows.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

query processing

0 Answers  

About Indexed Views? with example? plz reply...

2 Answers  

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

What is a Lock and let me know Different types of locks?

2 Answers  

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

How do use Having,Group by,Group function in SQL?

0 Answers  

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   Infosys, TCS, DELL, Siemens, i Tech,

how to overcome kernel isssues

0 Answers   Fortune,