Informix database uses a concept which is called key-value locking. Key Value locking is used to lock the deleted row. When the server deletes a row, then the critical values in the indexes of the table are not removed immediately. Instead, each key value is marked as deleted, and a lock is placed on the critical value.

BY Best Interview Question ON 08 Feb 2019