Explain locking. List its types.



Explain locking. List its types...

Answer / Samsher Singh

"Locking is a mechanism used in databases to prevent multiple transactions from accessing and modifying the same data simultaneously, thus ensuring data consistency and integrity. In Sybase, there are several types of locks such as table locks (shared and exclusive), page locks, row locks, and cursor locks. "

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Sybase Interview Questions

What is replication in sybase?

1 Answers  


What is the default table size in sybase?

1 Answers  


Can I run any transact-sql command on a partitioned table in sybase?

1 Answers  


What is procedure cache and data cache in sybase?

1 Answers  


List similarities and differences between oracle & sybase.

1 Answers  


What is sybase ?

1 Answers  


Differentiate between clustered and non-clustered index.

1 Answers  


How does sybase replication work?

1 Answers  


You need to manipulate varbinary columns in sybase. How would you do that?

1 Answers  


How configure sybase odbc connection?

1 Answers  


Can two tasks be assigned to the same partition in sybase?

1 Answers  


What are the operating systems in which sybase could take its presence?

1 Answers  


Categories