Answer Posted / rohit nanda

A constraint is a property assigned to a column or the set
of columns in a table that prevents certain types of
inconsistent data values from being placed in the columns.

There are 4 Types of Constraints.
• Entity Integrity - Primary and Unique
• Domain Integrity - Default, Check and Not Null
• Referential integrity – Foreign Key
• User-Defined Integrity - enforces some specific

What is a data collection table?

958

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

918

---

What are the two modes of authentication in sql server?

1003

---

What is the difference between dbcc indexdefrag and dbcc reindex?

949

---

Which sql server table is used to hold the stored procedure scripts?

1039

---

How to download microsoft sql server 2005 express edition?

988

---

what are database files and filegroups? : Sql server database administration

896

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

997

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1220

---

What are three major types of constraints?

1063

---

What is xml datatype?

1040

---

define and explain the differences between clustered and non-clustered indexes.

1134

---

When columns are added to existing tables, what do they initially contain?

994

---

Is sql server is free?

931

---

What type of locking occurs during the snapshot generation? : sql server replication

1276

---