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 record option in exp command.

1014

---

What the is the diff between local index and global index. give some example.

1647

---

What is a read only transaction in oracle?

1036

---

How to experiment a data lock in oracle?

1064

---

What are the attributes of the cursor?

1012

---

What are the tools for Oracle ?

1075

---

What is Segment Advisor in Oracle?

1110

---

How to create a table in a specific tablespace?

985

---

What is the difference between translate and replace in oracle?

1175

---

Can a parameter be passed to a cursor?

1138

---

How a database is related to tablespaces?

1046

---

What are the execution control statements in oracle?

1102

---

What is an oracle user account?

1002

---

Explain temporal data types in oracle

1100

---

How view is different from a table?

1047

---