Answer Posted / a.brahmam

mainly two types of locks
1.Row Level Locks
2.Table Level Locks

Table Level Locks Are Two Types
-------------------------------------------------
1.Share Lock
2.Exclusive Lock

What is catalog in Oracle?

1431

---

How to get a list of all user accounts in the database?

1129

---

Is primary key indexed by default in oracle?

1043

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2383

---

Explain the different normalization forms?

1152

---

How do I know if oracle client is installed on windows?

1090

---

What is oracle thin client?

1073

---

What is a package ? What are the advantages of package ?

1136

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1908

---

What is the purpose of save points in oracle database?

1196

---

How to use "startup" command to start default instance?

1095

---

Is there a function to split a string in plsql?

1104

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

1036

---

Can we store images in oracle database?

1063

---

How to create a testing table in oracle?

1031

---