Interested to Buy Any Domain ? << Click Here >> for more details...
what are different types of locks?
- 6 Answers
- 8611 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 |
What does ROLLBACK do ?
How can we force the database to use the user specified rollback segment?
which is the best training centre for learning oracle?
How to create a table in a specific tablespace?
What is a table in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is OCI. What are its uses?
What is enter substitution variable in oracle?
How to assign a tablespace to a users in oracle?
What is a nvl function?
How to create a stored program unit?
What are the types of Database Links ?
Oracle General 
