what are different types of locks?
- 6 Answers
- 7024 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 |
Explain the dml?
How can I introduce multiple conditions in like operator?
What do you mean by a tablespace?
What is a procedure in oracle?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
What would you do with an in-doubt distributed transaction?
How many memory layers are in the oracle shared pool?
How can we force the database to use the user specified rollback segment?
How to test null values?
What are the extensions used by oracle reports?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
Display Odd/ Even number of records?
Oracle General 
