Answer Posted / sandeep desai

Some more additions

With Truncate command Oracle sets the High Water Mark to
Zero
whereas
With Delete command this doesn't happen since data is not
released from the memory

Will you be able to store pictures in the database?

1125

---

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

1038

---

Difference between cartesian join and cross join?

1051

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1994

---

How much memory your 10g xe server is using?

1105

---

How will you differentiate between varchar & varchar2?

1047

---

What is the difference between 10g OEM and 11g OEM?

968

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2296

---

How to start your 10g xe server?

1045

---

How to create a table index?

1155

---

What is oracle instant client?

1028

---

Can we create trigger on materialized view in oracle?

998

---

What happens if you lost a data file?

1036

---

What to do if the binary spfile is wrong for the default instance?

1074

---

Why packages are used in oracle?

1072

---