Answer Posted / paridhi

select top 1 salary from
(select top 1 salary from employee order by
salary desc) a
order by salary

State the difference between a primary key and foreign key?

941

---

What is Java Pool in Oracle?

1176

---

What is the minimum client footprint required to connect c# to an oracle database?

1098

---

How a database is related to tablespaces?

1040

---

What is the scope of a local variable?

1068

---

what is reindexing?

1683

---

When do you get a .pll extension in oracle? Explain its importance

1045

---

What is the difference between Delete, Truncate and Drop in Oracle?

1132

---

What is a database schema in oracle?

1113

---

What is concurrency in oracle?

1011

---

What is the difference between online and offline backups?

1062

---

Describe an oracle table?

1056

---

How to define an anonymous procedure without variables?

1111

---

Explain an index?

1141

---

How to start a specific oracle instance?

1042

---