Answer Posted / amit tailor

Database normalization is the process of organizing data
into distinct and unique sets.
The purposes of normalization are to:
• Reduce or eliminate storage of duplicate data
• Organize data into an efficient and logica
structure

How to pass parameters to procedures in oracle?

585

---

Write a syntax for update query in oracle?

630

---

How to import one table back from a dump file?

605

---

How to run the anonymous block again?

607

---

What is the Tune Query

1859

---

---

What is tns name?

555

---

Can a parameter be passed to a cursor?

610

---

Difference between inner join vs where ?

621

---

Explain the different normalization forms?

607

---

How to lock and unlock a user account in oracle?

632

---

What privilege is needed for a user to create views in oracle?

608

---

Define oracle database

612

---

Explain the use of compress option in exp command.

558

---

How to increment dates by 1 in oracle?

572

---

What are the set operators union, union all, minus & intersect meant to do?

576

---