what are different types of locks?

Answer Posted / pratap dixit

Pessimistic and Optimistic lock
Pessimistic- at the time of reading , locking the row
Optimistic- at time of updating , locking the row.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null value in oracle?

638


Difference between open_form and call_form in oracle.

684


What is not equal to in oracle?

532


What is a connect identifier?

543


How to update values on multiple rows in oracle?

603






What is rowid and rownum in oracle?

545


What is blob data type in oracle?

561


what are steps for interface? where is exchange rate defined in which table?

1504


How to assign query results to variables?

594


What is a synonym? What are its various types?

626


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1851


What is a data dictionary and how can it be created?

617


What is backup in Oracle?

573


How to create id with auto_increment on oracle?

547


How to assign data of the deleted row to variables?

584