What is serializable?



What is serializable?..

Answer / Pranav Pradeep Saxena

Serializable is the highest isolation level in SQL Server. It ensures that each transaction appears to be executed serially, which means no concurrent execution of transactions can lead to conflicts. This guarantees consistency but may lead to increased locking and poor performance.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is set nocount on?

1 Answers  


What is the difference between local and global temporary tables?

1 Answers  


what is dbcc? : Sql server database administration

1 Answers  


How do I connect to sql server database?

1 Answers  


Can you explain important index characteristics?

1 Answers  


How to rename an existing column with sql server management studio?

1 Answers  


Can an entity have two primary keys?

1 Answers  


How to execute function in stored procedure sql server?

1 Answers  


Tell me about pre-defined functions of sql?

1 Answers   EXL,


What is ms sql server service broker?

1 Answers  


How to insert and update data into a table with "insert" and "update" statements?

1 Answers  


What are cursors?

8 Answers  


Categories