Answer Posted / lakshminarayana reddy

2 types
1. Implicit locks: oracle automatically locks the rows
whenever user performs DML operations.
2. Explicit locks: provided by user.
2 tpyes a) Row level locks: used to lock selected rows
of table.It is imposed by "for update" clause in select.
b) Table level locks: used to lock compleate
table. 3 models 1) share mode
2) share update
3) exlcusive mode

how to calculate expressions with sql statements? : Sql dba

979

---

Is sqlexception checked or unchecked?

917

---

Can we use two order by clause in query?

917

---

What is trigger types in sql?

941

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2411

---

What is trigger in sql? Explain

939

---

Are stored procedures faster than dynamic sql?

978

---

Can we write dml inside a function in sql server?

896

---

Can we rollback truncate?

940

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1057

---

Which is better cte or subquery?

969

---

What are the possible values for the boolean data field?

897

---

What normalization means?

903

---

What are tables and fields?

968

---

What are all the different types of indexes?

1090

---