Answer / Gaurav Bhatt

Database buffers contain copies of data blocks that have been read from data files into main memory. This allows Oracle to quickly retrieve and manipulate data without having to continuously read and write to the disk.

Point out the difference between user tables and data dictionary?

1 Answers  

---

How to view existing locks on the database?

1 Answers  

---

How to invoke the data pump export utility?

1 Answers  

---

What is the database name in oracle?

1 Answers  

---

What is index in Oracle?

1 Answers   MCN Solutions,

---

How to create additional tablespaces for an new database?

1 Answers  

---

Explain the function of optimizer in oracle?

1 Answers  

---

What is the difference between translate and replace in oracle?

1 Answers  

---

what is primary key?

9 Answers  

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

1 Answers   TCS,

---

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers  

---

How to create index-by table in oracle?

3 Answers  

---