Answer Posted / abcd

3 types:

1. DML,
2. DDL &
3. CLR (is it right?)

what are candidate key, alternate key and composite key? : Sql server database administration

904

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

953

---

What is the order in which the sql query is executed?

929

---

what is the information that can be stored inside a bit column? : Sql server database administration

947

---

What is shrink log file?

892

---

How to rename databases in ms sql server?

1185

---

Which is better statement or preparedstatement?

907

---

How to truncate the log in sql server 2012? : sql server database administration

1269

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1014

---

What is tabulation?

942

---

What is the use of custom fields in report?

987

---

When to use null data driven subscription?

204

---

What is stored in the mssqlsystemresource database? : sql server database administration

1019

---

What is the difference between lock, block and deadlock? : sql server database administration

1032

---

How does stuff differ from the replace function?

1004

---