Answer Posted / jasmine

Normalization is a process of designing the table(relation)
with the reduced redundancy and making clear whether the
attributes in a table is depend on the primary key or
dependencies make sense(ie:storing only the related datas
ito the table). This is achieved by normal forms.
Basic types of normal forms are,
1NF-first normal form(Eliminates duplicate or
repeating values)

2NF-second normal form(Eliminates redundant datas in
one or more tables)

3NF-Third normal form(Removing the columns that are
not truely depending on the primary key)

What is raw datatype in sql?

996

---

Is like operator in sql case sensitive?

976

---

How do you modify a column in sql?

958

---

What is clustered and nonclustered index in sql?

904

---

What is snowflake sql?

1021

---

How can you view the errors encountered in a trigger?

924

---

What is database migration?

927

---

Why query optimization is needed?

872

---

Explain the advantages and disadvantages of stored procedure?

1091

---

Does truncate need commit?

906

---

What company owns postgresql?

969

---

How do you modify a trigger?

883

---

what is the difference between union and union all? : Sql dba

987

---

What do you understand by pl/sql cursors?

1039

---

What is the difference between count 1 and count (*) in a sql query?

927

---