Answer Posted / valarmathi

'like' operator

What is the difference between local and global temporary tables?

1097

---

Define candidate key, alternate key, and composite key.

886

---

How to find table changes in sql server?

1074

---

How to list all schemas in a database?

1023

---

Explain the use of containers in ssis and also their types?

929

---

What stored by the model? : sql server database administration

919

---

What is a system database and what is a user database?

1043

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

999

---

What are wait types?

1041

---

Explain what are commit and rollback in sql?

883

---

What are locks in sql?

942

---

What are the different types of data sources in ssrs?

192

---

Explain about link server in sql server?

1021

---

What is the tcp/ip port on which sql server runs?

1092

---

What is a covered index?

905

---