Types of cursor locks and explanation each of them ?
Answer Posted / mehul patel
acLockPesimistic - locks the row when it read it and hold
the lock still updates it.
adLockOptimistic - locks the row whenit updates it.
adLockOptimistic - locks the row at the time it updates it.
adlockforwardonly - readonly.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is scalar function?
Does truncate release storage space?
Which tcp/ip port does sql server run?
What is meant by truncate in sql?
What are the types of views in sql?
How are functions and procedures called in PL/SQL?
What is the order of sql select?
Are stored procedures faster than dynamic sql?
what is rollback? : Sql dba
What is clustered and nonclustered index in sql?
Why is theta join required?
What problem one might face while writing log information to a data-base table in pl/sql?
What is trigger point?
What are the rules to be applied to nulls whilst doing comparisons?
What is a subquery in sql?