Answer Posted / faize

when query is executed in oracle then result set is
produced & stored in the memory.Oracle allows the
programmer to access this resultset in the memory through
cursors
two types of cursors:
1.Explict cursor
2.Implict cursor

Explain the importance of .pll extension in oracle?

1011

---

Design database draw er diagram for a certain scenario ?

4579

---

How to put more than 1000 values into an oracle in clause?

1029

---

various types of hints and their usage

2699

---

What is not equal to in oracle?

1003

---

definition of cluster and non-clustered index?

3035

---

How do I spool to a csv formatted file using sqlplus?

1033

---

How to work with data objects interactively?

982

---

How to turn on or off recycle bin for the instance?

1083

---

Is java required for oracle client?

999

---

What is the maximum number of triggers that can be applied to a single table?

1024

---

What do you understand by a database object?

1061

---

Can we call procedure inside function in oracle?

1093

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

---

Explain the function of optimizer in oracle?

1143

---