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.

Explain how are indexes update?

1064

---

Name the various constraints used in oracle?

1019

---

What is connection pooling in oracle?

968

---

How to create a stored procedure in oracle?

1102

---

How to do a full database export?

1106

---

How to define an anonymous block?

1154

---

How to create a table interactively?

1087

---

What are privileges and grants?

1065

---

What is oracle thin client?

1023

---

What are the advantages of oracle 12c?

1180

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1927

---

How to create a new user account in oracle?

1020

---

Difference between inner join vs where ?

1033

---

What is a subquery in oracle?

1109

---

What is connection pool in oracle?

988

---