Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shaheed ul haq sadi
1) Shared
A shared lock reserves its object for reading only. It
prevents the object from changing while the lock remains.
More than one program can place a shared lock on the same
object. More than one object can read the record while it is
locked in shared mode.
2) Exclusive
An exclusive lock reserves its object for the use of a
single program. This lock is used when the program intends
to change the object.
You cannot place an exclusive lock where any other kind
of lock exists. After you place an exclusive lock, you
cannot place another lock on the same object.
3) Promotable/Update
A promotable (or update) lock establishes the intent to
update. You can only place it where no other promotable or
exclusive lock exists. You can place promotable locks on
records that already have shared locks. When the program is
about to change the locked object, you can promote the
promotable lock to an exclusive lock, but only if no other
locks, including shared locks, are on the record at the time
the lock would change from promotable to exclusive. If a
shared lock was on the record when the promotable lock was
set, you must drop the shared lock before the promotable
lock can be promoted to an exclusive lock.
| Is This Answer Correct ? | 47 Yes | 9 No |
Post New Answer View All Answers
Explain the difference between drop and truncate commands in sql?
How do I install sql?
When you have to use a default "rollback to" savepoint of plvlog?
Is primary key a clustered index?
Explain the structure of pl/sql in brief.
What is the current version of postgresql?
How many sql statements are used?
Is postgresql a nosql database?
What is the difference between the sql*loader and import utilities? : aql loader
What is a temp table?
what is bcp? When is it used?
What is the sql query to display the current date?
How to avoid duplicate records in a query?
What is sql lookup?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
