Answer Posted / n.srivani

Normalization is a process to reduce the redundant data in
the database.

Explain the truncate in oracle?

967

---

What is Virtual Private Database in Oracle?

1091

---

How to display employee records who gets more salary than the average salary in the department?

1066

---

How to execute a stored program unit?

1077

---

How to open a cursor variable?

1039

---

 How to use an oracle sequence generator in a mapping?

1076

---

How do you store pictures in a database?

1007

---

What is the difference between a primary key & a unique key?

1090

---

how to handle exceptions in post production

1427

---

What is a proxy class?

1055

---

Briefly explain what is literal? Give an example where it can be used?

1043

---

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

1030

---

How to load data from external tables to regular tables?

1062

---

How to save query output to a local file?

1027

---

What is bind variable in oracle 11g?

1039

---