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.

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

1996

---

Can you drop an index associated with a unique or primary key constraint?

970

---

How to get execution path reports on query statements?

929

---

How to loop through data rows in the implicit cursor?

1016

---

How to return top 5 rows in oracle?

990

---

How to apply filtering criteria at group level in oracle?

987

---

What are dml statements in oracle?

1045

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2845

---

Does oracle charge for java?

1008

---

How to assign query results to variables?

1013

---

Why is oracle database so popular?

949

---

What is ASM (Automatic Storage Management) in Oracle?

1124

---

What is a trace file and how is it created in oracle?

974

---

Explain the use of tables option in exp command.

1054

---

How do I know if oracle is installed on windows?

881

---