Answer Posted / dilip tiwari

THis is for Oracle

SELECT * FROM emp
(SELECT empname,Salary,dense_rank() OVER(ORDER BY salary
DESC) AS ranking FROM emp)
WHERE ranking = 3

What is memory advisor in Oracle?

1027

---

How to define a specific record type?

1037

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4295

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5417

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

934

---

What is MTTR advisor in Oracle?

1035

---

What is the order of defining local variables and sub procedures/functions?

1006

---

How to write a query with an inner join in oracle?

976

---

What is merge statement used for?

973

---

What are the different windows events activated at runtime ?

2834

---

What are nested tables?

1107

---

What is columnar storage what is the advantage?

986

---

How to execute a stored procedure in oracle?

1031

---

Can we call procedure inside function in oracle?

1021

---

How to start an oracle instance?

953

---