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?

1111

---

How will you decide the active and passive nodes?

1186

---

How can you hide the sql server instances?

1075

---

What is the difference between value type and reference type?

992

---

Define magic tables in sql server?

1126

---

Explain different types of collation sensitivity?

1040

---

What command is used to rename the database?

1091

---

What is the sql server agent?

1150

---

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

1136

---

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

1124

---

Explain the properties of sub-query in sql server?

1074

---

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

1174

---

What are the advantages of using third-party tools?

1044

---