Answer Posted / peter

SQL> select max(sal) sal
2 from (select sal,
3 dense_rank() over
4 (order by sal desc) rnk
5 from emp )
6 where rnk = 2;

SAL
----------
3000

SQL>

Explain what are the uses of rollback segment?

1018

---

What do you mean by group by clause?

1049

---

What is bulk load in oracle?

1076

---

What are the various constraints used in oracle?

1048

---

how to make an oracle object

2363

---

What is SQL Tuning Advisor in Oracle?

1185

---

What is catalog in Oracle?

1372

---

Explain how you would restore a database using RMAN to Point in Time?

2149

---

what is the scripts in data base?

2160

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2211

---

How would you go about verifying the network name that the local_listener is currently using?

2050

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2262

---

What is the relationship among database, tablespace and data file?

993

---

What is a dynamic performance view in oracle?

998

---

Explain the use of analyse option in exp command.

1131

---