Answer Posted / karthik

In SQL Prompt:
-------------
set lines 100 pages 100;
set colsep"|"
spool c:\Datas.xls;
select * from emp
/
spool off;

In Excel Sheet, use Text to Column->Delimeter to replace
the "|" pipe symbol

Give the different types of rollback segments.

1031

---

What are the parameters that we can pass through a stored procedure?

1069

---

Can you have more than one content canvas view attached with a window ?

2333

---

Explain the difference between replace() and translate() functions in oracle?

1041

---

What are the roles of dba?

1070

---

what are the default admin accounts in Oracle 10g ?

972

---

When system tablespace is created?

1046

---

How to export several tables together?

1049

---

What is the usage of analyze command in oracle?

1095

---

Explain the use of compress option in exp command.

1021

---

How many types of tables are there in oracle?

1062

---

Explain what does a control file contain?

1105

---

What is rich query?

985

---

Can group functions be used in the order by clause in oracle?

999

---

What is tns service name?

1127

---