Answer / Gaurav Kumar Bajpai

Normalization is a process in database design aimed at organizing data in a way that minimizes redundancy, improves data integrity, and allows efficient manipulation. Normalization involves dividing a database into two or more tables, and defining relationships between them to ensure data consistency. There are several normal forms (NF) of which the most common are:
1. First Normal Form (1NF): Eliminates repeating groups and duplicates, ensuring each cell contains a single value.
2. Second Normal Form (2NF): Each non-key column depends on the primary key.
3. Third Normal Form (3NF): Eliminates transitive dependencies, where a non-key column does not depend on any other non-key columns.
4. Boyce-Codd Normal Form (BCNF): No non-trivial functional dependency involves a proper subset of the primary key.
5. Fourth Normal Form (4NF): All relations are in 3NF and have no multi-valued dependencies or join dependencies.

What protocol does sql server use?

1 Answers  

---

How can you fetch alternate records from a table?

1 Answers  

---

What is raid and what are different types of raid levels?

1 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

Mention a few common trace flags used with sql server?

1 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1 Answers  

---

What is the difference between count () and rowcount ()?

1 Answers  

---

What is multilevel indexing?

1 Answers  

---

Does partitioning improve performance?

1 Answers  

---

What are page splits?

1 Answers  

---

Describe in brief sql server monitoring ways.

1 Answers  

---