DEVFYI - Developer Resource - FYI

What is concurrency

ORACLE Interview Questions and Answers (Part 4)

(Continued from previous question...)

613. What is concurrency

Cuncurrency is allowing simultaneous access of same data by different users. Locks useful for accesing the database are
a) Exclusive
The exclusive lock is useful for locking the row when an insert,update or delete is being done.This lock should not be applied when we do only select from the row.
b) Share lock
We can do the table as Share_Lock as many share_locks can be put on the same resource.

(Continued on next question...)

Other Interview Questions