Answer Posted / parifs

1. Control Panel>>Admin Tools>>Data Services (ODBC)>>

2. From ODBC Data Source Administrator dialog, select
requires DSN type
(User DSN, System DSN, File DSN). From the selected DSN,
click ?Add? button and select the required driver and
click ?Finish? button.

3. From ODBC Text Set up enter the Data Source Name and
Description.
Select the DB and click Ok button.

4. DSN is created.

What is meant by joins? List out the types of joins.

1103

---

How to use "while" statements in oracle?

1377

---

 How to use an oracle sequence generator in a mapping?

1130

---

How to list all user accounts in oracle?

1065

---

State the various uses of dbcc command?

1104

---

What is oracle used for?

1069

---

Explain compound trigger in oracle?

1088

---

What is ASM (Automatic Storage Management) in Oracle?

1242

---

How to open and close an explicit cursor in oracle?

1095

---

what is the difference between substr and instr function in oracle?

1142

---

What is materialized view in Oracle?

1114

---

What is SQL Tuning Advisor in Oracle?

1248

---

Explain the difference between a procedure and a function?

1239

---

what are archived logs?

2259

---

How to connect ms access to oracle servers?

1056

---