Answer Posted / nishi

It is area in memory that is used by a Single Oracle User Process. Whenever a server process is started a sertain amount of PGA memory is automatically allocated through the server process.

Is java required for oracle client?

1001

---

What are the restrictions in a oracle read only transaction?

1035

---

How to view all columns in an existing table?

936

---

Explain about your project and its relation to the current job position you are applying to?

1011

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2971

---

How to load data through external tables?

1136

---

How does Oracle guarantee data integrity of data changes?

2390

---

What is Redo Log Buffer in Oracle?

1209

---

What is a table index in oracle?

1131

---

How to rebuild an index in oracle?

1028

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2116

---

What is Reduced List of Values?

2167

---

How to grant create session privilege to a user in oracle?

1002

---

How to invoke the data pump export utility?

1187

---

How to open a cursor variable?

1039

---