Answer / Veerendra Kumar

Normalization is a process to organize data in a database to reduce redundancy and improve data integrity. It involves dividing tables into smaller tables that adhere to specific rules (like 1NF, 2NF, and 3NF).

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1 Answers   MCN Solutions,

---

Explain the etl (extraction, transformation, and loading)?

1 Answers  

---

What is the importance of a recovery model?

1 Answers  

---

A trigger can reference objects outside the current database? State true or false.

1 Answers  

---

What are scalar functions?

1 Answers  

---

How to fetch the next row from a cursor with a "fetch" statement?

1 Answers  

---

What language is sql server written in?

1 Answers  

---

Explain different backup plans?

1 Answers  

---

Is it safe to delete log files?

1 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

What are information schema views?

1 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

1 Answers  

---