Interested to Buy Any Domain ? << Click Here >> for more details...
what are different types of locks?
- 6 Answers
- 8409 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bibhuti bhusan patra
implicit locks & explicit locks
implicit locks are maintained by oracle internally.
&explicit locks are performed by user manualy.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shanmugavelu
row level and table level locks,
dont try share update lock its failure in table lelvel ..
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / a.brahmam
mainly two types of locks
1.Row Level Locks
2.Table Level Locks
Table Level Locks Are Two Types
-------------------------------------------------
1.Share Lock
2.Exclusive Lock
| Is This Answer Correct ? | 0 Yes | 0 No |
How to load data through external tables?
Explain a synonym?
What is merge statement used for?
what is the use of system.effective.date variable in oracle?
What is the difference between translate and replace?
What would you do if a database crashes in production?
Point the difference between translate and replace?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How to generate query output in html format?
How can I create database in oracle?
What is STATSPACK tool?
Oracle General 
