What are the system database in sql server 2005?

545

---

Define clusters?

641

---

How we can refresh the view?

585

---

What is the difference between set and select?

565

---

What is the difference between stored procedure and user defined functions?

613

---

What area unit the various kinds of info compression introduced in sql server 2008?

561

---

What is the contrast between sql and mysql?

584

---

What are the different types of sub-queries?

594

---

How to choose all records from the table?

644

---

What is an index. What are the types?

576

---

What happens on checkpoint?

606

---

Distinguish between nested subquery and correlated subquery?

539

---

Define synonym?

724

---

What are the different ways you can create databases in sql server?

562

---

How many null values we can have in a unique key field in sql server?

544

---