Answer Posted / daji surwase

select salary
from employees
order by salary desc
offset 2 rows fetch next 1 row only;

How to drop an index in oracle?

1121

---

List the types of joins used in writing subqueries?

1038

---

what are the advantages of running a database in archive log mode?

2258

---

What is the difference between post-database commit and post-form commit?

1286

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4572

---

How to define a variable of a specific record type?

1117

---

What is the difference between a primary key & a unique key?

1141

---

How to create a single index for multiple columns?

1086

---

How many data types are supported?

1140

---

How do I uninstall oracle client from windows?

1059

---

What is redo log?

1116

---

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

2450

---

Explain about functional dependency and its relation with table design?

1061

---

What are the various oracle database objects?

1204

---

What is the use of file param in imp command?

1218

---