Answer / md mubeen

Shared pool buffers cache consists of two layer
1)Library cache (LC) 2) Data dictionary cache (DDC)
in the Library cache the parsed information data will be
stored 2)DDC contains the dictionary tables which stores
the meta data information .

How to view all columns in an existing table?

1 Answers  

---

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

1 Answers  

---

How to lock and unlock a user account in oracle?

1 Answers  

---

What are nested tables?

1 Answers  

---

Explain the use of control file?

1 Answers  

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

various types of hints and their usage

1 Answers  

---

How to use "out" parameter properly?

1 Answers  

---

What the is the diff between local index and global index. give some example.

1 Answers   TCS,

---

What is the difference between RBBMS & DBMS?

4 Answers  

---

When a form is invoked with call_form, Does oracle forms issues a save point ?

1 Answers   Oracle,

---

What are the predefined tablespaces in a database?

1 Answers  

---