Answer Posted / paridhi

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

How to create a new table by selecting rows from another table?

1151

---

Give the advantages and disadvantages of clusters.

1097

---

What is format trigger?

2121

---

What are the advantages of oracle 12c?

1237

---

How to see the table columns used in an index?

1072

---

Explain table?

1178

---

What does sharding mean?

1056

---

Explain implicit cursor.

1075

---

What is a cursor in oracle?

1232

---

What is the sid in oracle?

1033

---

What is a nvl function? How can it be used?

1099

---

What are the most common interview questions on ETL Testing for experience?

1190

---

What are the attributes of cursor?

1105

---

How can we force the database to use the user specified rollback segment?

1201

---

What to do if the startbd.bat failed to start the xe instance?

1129

---