Answer / Jitendar Singh

SQL Server Replication provides four main types: Transactional Replication, Merge Replication, Snapshot Replication, and Peer-to-Peer Replication.

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

If no size is defined while creating the database, what size will the database have?

1 Answers  

---

How to disconnect from a sql server using mssql_close()?

1 Answers  

---

What are the database roles? : sql server security

1 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---

What are the differences between decimal and float in ms sql server?

1 Answers  

---

What are the kinds of subquery?

0 Answers  

---

What are the encryption mechanisms in sql server?

1 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1 Answers  

---

What are magic tables in sql server?

1 Answers  

---