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.

Explain different types of locks in sql server.

1127

---

What is the use of group by clause?

990

---

How to access the inserted record of an event?

1107

---

Explain the benefits of user-defined functions?

1121

---

What are the dis_advantages of stored procedures, triggers, indexes?

2273

---

What is database dimension? : sql server analysis services, ssas

1138

---

How much memory that we are using in Logshipping Concept?

1843

---

Explain the properties of the relational tables?

1029

---

How to change a login name in ms sql server?

1132

---

How do I run sql server 2014?

1054

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1092

---

What is a trigger? Why we need it?

1054

---

What is user-defined function?

1033

---

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

1277

---

What is normalization? Explain different forms of normalization?

1226

---