Answer Posted / krishna

delete from emp where sal >(select max(sal) from emp where
sal >(select max(sal) from emp where sal >(select max(sal)
from emp)));

What suggestions do you have to reduce the network traffic?

557

---

What is connection pooling in oracle?

561

---

What is meant by joins? List out the types of joins.

531

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

597

---

What is the data type of dual table?

535

---

---

How to experiment a data lock in oracle?

605

---

How to set up autotrace for a user account?

602

---

What happens to the current transaction if the session is ended?

535

---

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

548

---

How to create a table index in oracle?

665

---

How to start your 10g xe server from command line?

552

---

Explain the use of online redo log files in oracle.

595

---

How to update values on multiple rows in oracle?

606

---

What is an oracle data file?

619

---

Can we write insert statement in function in oracle?

541

---