Answer Posted / shahnaz

To find the 2nd highest salary from emp table:

select max(sal) from emp where sal not in (select max(sal)
from emp )

How to use "if" statements on multiple conditions?

1217

---

What is the recommended interval at which to run statspack snapshots, and why?

2963

---

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

1088

---

How to change program global area (pga) in oracle?

1147

---

What is a database schema in oracle?

1151

---

what are bitmap indexes? How does they work?

2303

---

What is raw datatype in oracle?

1210

---

What are the ways tablespaces can be managed and how do they differ?

2446

---

How to delete a user account in oracle?

1021

---

How to assign values to data fields in record variables?

1078

---

How to define an anonymous procedure with variables?

1240

---

How will you differentiate between varchar & varchar2?

1086

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2286

---

How would you go about verifying the network name that the local_listener is currently using?

2108

---

What is the difference between primary key and unique key and foreign key in oracle?

1036

---