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.

Which operator is used in query for pattern matching?

1089

---

What is difference between inner join and self join?

1085

---

Can we perform dml in function?

1067

---

What operators deal with null?

1107

---

how to create a test table in your mysql server? : Sql dba

1008

---

how to delete an existing column in a table? : Sql dba

1005

---

How will you distinguish a global variable with a local variable in pl/sql?

1154

---

Is null operator in sql?

1041

---

What is embedded sql in db2?

1020

---

what is sql profiler? : Sql dba

1048

---

What is difference between sql and excel?

1095

---

Does sql view stored data?

959

---

What is sql scripting?

1124

---

what is query cache in mysql? : Sql dba

1037

---

Which tcp/ip port does sql server run?

1008

---