Interested to Buy Any Domain ? << Click Here >> for more details...
what are different types of locks?
- 6 Answers
- 8792 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 |
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
how may join possible between (requisition with purchase order)
What is the difference between Outer join and Full outer join?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
how to insert the image in table
Explain an exception and its types?
how to tune oracle sql queries pls tell me step by step. urgent pls
what is pragma?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
What is enter substitution variable in oracle?
How to display employee records who gets more salary than the average salary in the department?
How a tablespace is related to data files?
Oracle General 
