Answer Posted / raji_4u

in share mode :
this mode is for read only on entire table.
we can not make changes to table.
any user can have a lock in share mode at same time.

in share update mode :
this mode is used to lock the selected rows for update.
this mode acquires lock on selected rows only,not entire table.
other user can have lock on other rows on the same table but
not on the rows you have locked.

in exclusive mode :
this acquires lock on entire table.
another user can not have any lock on that table.

What is dml and ddl?

1011

---

What is information schema in sql?

1119

---

What is difference between group by and partition by?

1129

---

What is a variable in sql?

1054

---

What are triggers and its types?

1120

---

Is ms sql is free?

1083

---

Can we use commit inside a trigger?

1147

---

what are the 'mysql' command line arguments? : Sql dba

1193

---

What is procedure and function?

1035

---

Explain the rollback statement?

1072

---

Is oracle sql free?

1039

---

What are procedures used for?

1038

---

What is the sql*loader? : aql loader

1103

---

What is the best sql course?

1028

---

Is full outer join same as cross join?

1018

---