Answer Posted / vinod

Constraints are used to restrict the insertion of unwanted data.
Using constraints you can maintain data integrity by preventing invalid data being entered.

Constraints are Five type
Primary key
Unique Key
Foreign Key
Not Null
Check

List out the different types of locks available in sql server?

978

---

What are security principals used in sql server 2005?

988

---

What programming language would you use to create embedded functions in ssrs?

184

---

How exceptions can be handled in sql server programming?

1015

---

What is rank function?

1033

---

What is implicit mode in sql server?

1106

---

How do I find information about the install locations for the various instances running on a computer?

1085

---

What are the character string functions supported by sql server 2005?

1014

---

When does a workload on SQL Azure get throttled?

131

---

What is the difference between ddl and dml?

1048

---

List the different normalization forms?

984

---

why would you use sql agent? : Sql server database administration

1215

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

966

---

What is difference between global temporary tables and local temporary tables?

1238

---

What is the difference between Clustered and Non-Clustered Index?

1059

---