The lock mode convey the message of lock status starting from low level h

what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?

Question Posted / ajay.lavanuru

3 Answers
11354 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / ajay.lavanuru

The lock mode convey the message of lock status starting
from low level hierarchy to high level hierarchy.

exclusive lock ---high priority
if this lock is enabled then 1 cant do nothing on the table.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is user defined functions? : Sql dba

1039

What is cte sql?

1007

Why query optimization is needed?

932

Can we join 3 tables in sql?

1054

What are the types of keys?

1005

What is trigger in sql and its types?

1075

How many types of tables are there?

963

What is materialized view in sql?

928

What are different types of functions in sql?

1013

Is sql port 1433 encrypted?

1039

how do you login to mysql using unix shell? : Sql dba

1088

How delete all records from table in sql?

986

How do I kill a query in postgresql?

1149

Why is sql better than hql?

1004

Can we join same table in sql?

1036