|
INTERVIEW QUESTIONS
DATABASE
INFORMIX
DETAILS
Question: What are the uses of key value locking in Informix?
Answer: The 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.
Without this protection mechanism, user A might delete a unique key within a transaction, and user B might insert a row with the same key before the transaction commits. This scenario makes rollback by user A impossible. Key-value locking prevents user B from inserting the row until the end of user A's transaction.
|
|
|
Category |
Informix Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7561 users |
Added on |
4/3/2013 |
Views |
67497 |
Rate it! |
|
|
Question:
What are the uses of key value locking in Informix?
Answer:
The 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.
Without this protection mechanism, user A might delete a unique key within a transaction, and user B might insert a row with the same key before the transaction commits. This scenario makes rollback by user A impossible. Key-value locking prevents user B from inserting the row until the end of user A's transaction. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Who conceived and designed the Informix database management system?
|
View Answer
|
|
What is Informix Binary Large Object?
|
View Answer
|
|
What is Informix instance?
|
View Answer
|
|
What is extent in Informix?
|
View Answer
|
|
What is chunk in Informix?
|
View Answer
|
|
xplain about light scans in Informix?
|
View Answer
|
|
What is the option or command used in Informix for finding which dbspace a database resides?
|
View Answer
|
|
Mention the database server operating modes available for Informix?
|
View Answer
|
|
Who developed informix?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Informix Interview Questions & Answers - Exam Mode /
Learning Mode
|