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


Please Help Members By Posting Answers For Below Questions

What is mutating error in pl sql?

555


Explain what is table in a database?

590


Does sql profiler affect performance?

561


How to place comments in pl/sql?

612


What are the operators in sql?

536






How much does sql certification cost?

554


Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1692


What is the usage of sql functions?

551


Which is faster view or stored procedure?

508


what is top in tsql? : Transact sql

551


how to return query output in html format? : Sql dba

657


What is interval partition?

548


Can we perform dml on view?

559


What is sql analyzer?

547


Explain spool.

691