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

Explain system scalar functions?

0 Answers  


Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  


Can we create nonclustered index in a table without creating a clustered index

1 Answers  


What is dknf in normalization form?

0 Answers  


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  






what is the disadvantage of SQL Loder?

1 Answers   TCS,


How to view the error log for any specific instance? : sql server database administration

0 Answers  


what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  


What are secondary xml indexes?

0 Answers  


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  


What is log cache in sql server?

0 Answers  


How to download microsoft sql server 2005 express edition?

0 Answers  


Categories