Answer / Siddharth Verma

Normalization in SQL is a process to organize data in a relational database to minimize redundancy and dependency. There are three normal forms: First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). 1NF eliminates repeating groups, 2NF eliminates partial dependencies, and 3NF eliminates transitive dependencies.

How to look at the current sql*plus system settings?

1 Answers  

---

Which join is like an inner join?

1 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

how to connect oracle in unix prompt?

4 Answers   Polaris,

---

How to assign sql query results to pl sql variables?

1 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

Explain the insert into statements in sql?

1 Answers  

---

Explain mutating table error.

1 Answers  

---

what is a database transaction? : Sql dba

1 Answers  

---

Is left join faster than inner join?

1 Answers  

---

What is the difference between sql, mysql and sql server?

1 Answers  

---

What is recursive join in sql?

1 Answers  

---