Answer Posted / prem

SQL> select salary from(select salary,rownum a from(select salary from employee order by salary desc))where a=2;

How to start your 10g xe server?

1087

---

What is the difference between translate and replace?

1114

---

How many types of database triggers exist?

1183

---

Can we write dml statement in function in oracle?

1121

---

Explain the use of grant option in exp command.

1106

---

How to create a temporary table in oracle?

1329

---

What is the purpose of save points in oracle database?

1199

---

Explain the use of grant option in imp command.

1078

---

How do I spool to a csv formatted file using sqlplus?

1083

---

How to use windows user to connect to the server?

1043

---

How to test null values?

1154

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1981

---

Explain compound trigger in oracle?

1087

---

What is the difference between alert log file and tarce file ?

2223

---

How to see free space of each tablespace?

1080

---