In which tcp/ip port does sql server run? Can it be changed?

1042

---

What is "scheduled jobs" or "scheduled tasks"?

1032

---

What is the dbcc command and why is it used?

1110

---

How will you decide the active and passive nodes?

1184

---

How can you hide the sql server instances?

1073

---

What is the difference between value type and reference type?

992

---

Define magic tables in sql server?

1124

---

Explain different types of collation sensitivity?

1037

---

What command is used to rename the database?

1089

---

What is the sql server agent?

1148

---

What is sub-query in sql server? Explain its properties.

1134

---

What is the most common trace flags used with sql server?

1121

---

Explain the properties of sub-query in sql server?

1072

---

What are the different types of collation sensitivity in sql server?

1173

---

What are the advantages of using third-party tools?

1041

---