Informix Question: Download Questions PDF
What are the uses of key value locking in Informix?
he database server uses a concept called key-value locking to lock the deleted row. When the database server deletes a row, key values in the indexes for the table are not removed immediately. Instead, each key value is marked as deleted, and a lock is placed on the key value. One of the most important uses for key-value locking is to assure that a unique key remains unique through the end of the transaction that deleted it.
Download Informix Interview Questions And Answers PDF
|Previous Question||Next Question|
|What is Informix instance?||Who conceived and designed the Informix database management system?|