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 to display employee records who gets more salary than the average salary in the department?

1066

---

What is a database table in oracle?

1023

---

What do you understand by database schema and what does it hold?

1230

---

How to connect to the server with user account: sys?

1022

---

How to select an oracle system id (sid)?

1064

---

Explain oracle’s system global area (sga).

1139

---

Explain the use of record option in exp command.

1006

---

How will you identify oracle database software release?

1010

---

What happens to the data files if a tablespace is dropped?

1059

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1034

---

Explain the use of parfile option in exp command.

1069

---

Difference between varchar and varchar2 data types?

1184

---

How do we display rows from the table without duplicates?

972

---

How to login to the server without an instance?

1163

---

What is hash cluster in oracle?

1174

---