Answer Posted / divya

select min(sal) from salarytbl where sal in(select distinct
top 3 sal from salarytbl order by sal desc)

What is tns name?

1029

---

Explain the function of optimizer in oracle?

1202

---

How to get a create statement for an existing table?

1016

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2042

---

Can multiple cursors being opened at the same time?

1117

---

what is the difference between data migration and production migration.

2401

---

How to set a transaction to be read only in oracle?

1140

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2200

---

How to create a server parameter file?

1188

---

What is a read write transaction in oracle?

1134

---

Write a syntax for update query in oracle?

1076

---

What do you mean by merge in oracle and how can you merge two tables?

1007

---

How to invoke the data pump export utility?

1255

---

What to do if dba lost the system password?

1248

---

What is the Tune Query

2347

---