Answer Posted / sudhir g. mali

To Resolve DB issues(inconsistency, redundancy & ambiguity) some amount of refinement required. This refinement process is called as Normalization.

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

616

---

What are the attributes of the cursor?

561

---

How to create an oracle database manually?

568

---

what is dynamic SGA and static SGA

3840

---

What is a nvl function?

566

---

---

Explain the use of parfile option in exp command.

526

---

What is the Tune Query

1846

---

Query to retrieve record for a many to many relationship ?

2080

---

In the oracle version 9.3.0.5.0, what does each number shows?

751

---

What is an oracle recycle bin?

551

---

Difference between open_form and call_form in oracle.

679

---

What is background process in Oracle?

626

---

Explain constraining triggers.

596

---

In oracle there is column command, how will you explain that?

552

---

How to add another datafile to a tablespace?

577

---