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

What is full form of rtm?

1008

---

Is sql low level language?

1020

---

what is a materialized view? : Sql dba

1061

---

What is number function in sql?

972

---

What is dml statement?

955

---

What does pl sql developer do?

926

---

What are the advantages of stored procedure?

1004

---

What is pl/sql language case sensitive?

1126

---

What is the purpose of primary key?

1027

---

How do I view a table in sql?

1007

---

what are local and global variables and their differences? : Sql dba

1070

---

explain normalization concept? : Sql dba

1046

---

What are all ddl commands?

1085

---

What is meaning of <> in sql?

1068

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

1059

---