Answer Posted / shivaprasad

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

Explain the use of file option in exp command.

1132

---

What is the difference between sharding and replication?

1056

---

How to connect to oracle using service name instead of sid?

1026

---

What happens to the indexes if a table is recovered?

993

---

Explain oracle 12c new features for developers?

1061

---

What do you mean by merge in oracle?

996

---

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

1019

---

What is a trigger and what are its types?

1231

---

How much memory your 10g xe server is using?

1103

---

Explain the use of owner option in exp command.

1048

---

Why does for update in oracle 8 cause an ora-01002 error?

1003

---

How many types of cluster table in Oracle?

1034

---

How is it different from a normal table?

1037

---

What is tns entry?

1156

---

What is a user account in oracle?

1121

---