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

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

If a stored procedure is taking a table data type, how it looks?

1 Answers  

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

What is the default value of CHAR type?

10 Answers   Bosch,

Can we create a clustered index on composite primary key.

3 Answers   IGT,

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

What is the difference between temp table and table variable?

8 Answers   Microsoft,

Can we drop user if user mapped to any logins

1 Answers