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
11271 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 a temporal table?

915

What are the different ddl commands in sql?

1129

What is scope and visibility in PL/SQL?

1177

how do you know the version of your mysql server? : Sql dba

986

What is nosql db?

954

What is a table in a database?

1032

What are the string functions in sql?

958

What is union?

1134

how to use case expression? : Sql dba

996

What is Histogram?

1545

explain the advantages and disadvantages of stored procedure? : Sql dba

990

Explain some predefined exceptions.

1018

What are schema-level triggers?

1083

Explain the types of joins in sql?

1014

Is sql a case sensitive language?

915