How can you list all the table constraints in a database?

985

---

explain extended properties

1038

---

What are the results of running this script?

976

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1053

---

How can you stop stored procedures from recompiling?

950

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1038

---

What is a livelock?

1024

---

What are alternate keys?

1033

---

What does it mean to normalize a database and why would you do it?

1024

---

‘Order by’ is not allowed in a view how can you sort information from a view?

1122

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

993

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1090

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

1175

---

What is xdr?

1044

---

How can you set the threshold at which sql server will generate keysets asynchronously?

1052

---