Interested to Buy Any Domain ? << Click Here >> for more details...
For Read Stability locks are not applicable for phantoms,
What is Phantoms?
- 2 Answers
- 6441 Views
- I also Faced
- E-Mail Answers
Answer Posted / santoshkumar jangamashetti
example for Phantoms:
• Transaction1 opens a cursor and reads account
information, keeping a running sum of the total balance for
the selected accounts.
• Transaction2 inserts a new account that falls
within the range of accounts being processed by
Transaction1, but the insert occurs after Transaction1 has
passed the new account.
• Transaction2 commits the insert.
• Transaction1 runs a query to sum the values to
check the accuracy of the running total. But the totals
will not match.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Define check constraint.
How is deadlock resolved?
What is deadlock in db2?
What is ibm db2 database?
Why select is not preferred in embedded sql programs?
What is the use of db2?
What is bufferpool in db2?
What is the role of data manager in the db2 database?
How does db2 sample database connect?
What is a dbrm in db2?
How to check last update on table in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
what is diffrence b/w file-aid tool and file-aid utility???
Why do we use cursor?
What is sqlca?
