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

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  


How to list all tables having unique constraints in any of the columns in a database.

1 Answers  


Explain SELF JOIN ?

3 Answers   ADP,


What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,


What is the order in which the SQL query is executed? list them in order.

5 Answers   Oracle, CTS, CarrizalSoft Technologies,






how can u get last observation in an unknown dataset ?

0 Answers   Genpact,


How to handle errors in Stored Procedures.

2 Answers   Accenture,


How to work on DTS?what is the main requirement?

1 Answers   ivan, Getit,


how can i view structure of table in sql server? tell me that query.

10 Answers  


what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,


What is normalization and what are the different forms of normalizations?

2 Answers  


Alternative way to DetDate() function?

5 Answers  






Categories