Answer Posted / mohib

there are two types of
constraints
1;holonomic
constraint
2;non-holonomic constraints

Mention the different authentication modes in sql server.

1109

---

Can you please explain the difference between primary keys and foreign keys?

1173

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

1093

---

Do you know what is xpath?

1158

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1270

---

What is the command dbcc checkdb used for?

1074

---

What is the difference between resultset and resultsetmetadata?

1032

---

How to create sub reports?

251

---

What is report snapshot?

163

---

What happens if null values are involved in comparison operations?

1046

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1187

---

What does truncate do?

998

---

What are the steps you should follow to start sql server in single-user mode?

956

---

How to convert binary strings into integers in ms sql server?

1083

---

Does server sql treat char as a variable-length or fixed-length column?

1095

---