Answer / Kamlesh Kumar Singh

Normalization is the process of organizing a database to minimize data redundancy and dependency, improving efficiency and enforcing data integrity. It's based on several normal forms (NF) to establish rules for how tables should be structured. The main levels are:nn1) First Normal Form (1NF): Each column must contain atomic values (indivisible), and each table row must be unique.n2) Second Normal Form (2NF): A table should be in 1NF, and every non-key attribute should depend on the primary key.n3) Third Normal Form (3NF): A table should be in 2NF, and there should not exist any transitive dependencies (one non-prime attribute depends on another non-prime attribute that is part of the primary key).nThere are further normal forms like Boyce-Codd Normal Form (BCNF), Fourth Normal Form (4NF), and Fifth Normal Form (5NF), but they are less commonly used.

Can we add an identity column to decimal datatype?

1 Answers  

---

What is a Trace frag?Where can we use this?

1 Answers  

---

Explain what is log shipping?

1 Answers  

---

What is self contained sub query?

0 Answers  

---

What is difference between rownum and row_number?

1 Answers  

---

What does top operator do?

1 Answers  

---

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

Are all views updatable ?

1 Answers   MCN Solutions,

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

Explain about system stored procedure?

1 Answers  

---

How can we improve performance by using SQL Server profiler?

1 Answers   QuestPond,

---