Answer Posted / mohan

Constraint is nothing but set of rules or restrictions on a column,in order to achieve business requirements.

There are five types of constraints,
they are
1.primary key
2.unique key
3.not null
4.check
5.foreign key

These constraints also called data integrity constraints.

what are the three command line utilities and what are their primary functions?

145

---

How to select some specific columns from a table in a query in ms sql server?

1005

---

What are the default system databases in sql server 2000?

1031

---

How do I find the query plan in sql server?

962

---

What is the difference between left and right outer join?

1063

---

How can I create a report based on a query? : sql server management studio

1016

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1073

---

What is 2nf example?

995

---

What is the temp table?

924

---

What is sql language?

1146

---

What are the properties of sub-query?

1074

---

Can you explain about buffer cash and log cache in sql server?

949

---

What is similarity and difference between truncate and delete in sql?

1102

---

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

966

---

What are null values in ms sql server?

1089

---