Interested to Buy Any Domain ? << Click Here >> for more details...
what are different types of locks?
- 6 Answers
- 8529 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 are the components of logical database structure in oracle database?
What is trigger associated with the timer ?
What is a cognitive schema?
How to execute the package in oracle?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is the minimum client footprint required to connect c# to an oracle database?
What do you mean by redo log file mirroring?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Why is oracle so popular?
What is different types of joins?
Shall I get Pro*C Compiler in Oracle-10g release ?
Oracle General 
