Pessimistic and Optimistic lock Pessimistic- at the time of reading , lock

what are different types of locks?

Question Posted / pratap dixit

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

Please Help Members By Posting Answers For Below Questions

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1986

How to convert dates to characters in oracle?

1019

Difference between pre-select and pre-query

1081

Why should I use oracle database?

975

What is instant client oracle?

1011

In oracle there is column command, how will you explain that?

1020

Explain the difference between sql and oracle?

1059

Explain a private synonyms?

1013

How do I manually uninstall oracle client?

1069

Explain oracle’s system global area (sga).

1127

How many types of synonyms in Oracle?

1103

How to do clean up if create database failed?

1013

Why use resource manager in Oracle?

1090

What are a collation and state the different types of collation sensitivity?

1149

What is Undo Management Advisor in Oracle?

1080