Answer Posted / ramesh.n

constraints are the restrictions or limitations that are
being imposed on the columns of a table to validate the data
either for insertion or updation constraints can be imposed
either during the process of table creation of a level.

There are 8 types of constraints
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key
7.composite primary key
8.composite unique key

Explain filtered indexes?

931

---

What are the advantages dts has over bcp?

939

---

What are the differences between left join and inner join in sql server?

1038

---

What protocol does sql server use?

881

---

Tell me about builtinadministrator?

945

---

What do you mean by collation recursive stored procedure?

1009

---

What is lock escalation? : sql server database administration

1101

---

What is the command dbcc checkdb used for?

962

---

what is difference between view and Dip.

2371

---

How many tables can be joined in SQL Server?

1003

---

What is query parameter in ssrs?

143

---

Tell me the phases a transaction has to undergo?

917

---

what is datawarehouse?

1050

---

How do you identify a foreign key?

965

---

List all the types of user-defined functions?

990

---