Answer Posted / ananth

this is for 2nd highest sal in sql server database

select * from emp where sal=(select max(sal) from emp where
sal<(select max(sal) from emp))

What is the difference between online and offline backups?

562

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3831

---

Write a trigger example in oracle?

575

---

what is dynamic SGA and static SGA

3843

---

Describe an oracle table?

576

---

---

Can objects of the same schema reside in different tablespace?

590

---

How to convert dates to characters in oracle?

584

---

Explain the use of consistent option in exp command.

552

---

Can group functions be mixed with non-group selection fields?

536

---

Explain what are the uses of rollback segment?

588

---

Can select statements be used on views in oracle?

596

---

How to run create database statement again?

623

---

How to speed up webrick?

596

---

What is the exact use of Collections?

1682

---

What is raw datatype?

595

---