Answer Posted / dhanya

select rnk, no,sal from (
SELECT DENSE_rank()over(partition by no order by sal desc ) RNK,d2.no,sal FROM DUMMY2 d2)
where rnk =2;

What is meant by a deadlock situation?

1053

---

What is the difference between sharding and replication?

956

---

What is a database schema in oracle?

1055

---

How to create an oracle database?

978

---

How to pass a cursor variable to a procedure?

1042

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2251

---

What is index in Oracle?

1014

---

What is a trigger and what are its types?

1115

---

What is oracle join syntax?

945

---

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

934

---

Can group functions be mixed with non-group selection fields?

963

---

what are archived logs?

2143

---

What are the attributes of cursor?

990

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1047

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2577

---