Answer Posted / nambi rajan

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
business rules that do not fall into entity, domain, or
referential integrity categories

What happens if null values are involved in boolean operations?

940

---

Why de-normalization required?

940

---

Can foreign key be duplicate?

999

---

Why it is recommended to avoid referencing a floating point column in the where clause?

919

---

What objects does the fn_my_permissions function reports on? : sql server security

991

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

937

---

how we use window authentication connection with sql server.?

1084

---

What is the temp table?

866

---

How to connect php with different port numbers?

1002

---

Define msdb database?

972

---

Explain the third normal form(3nf)?

893

---

Can we write a distributed query and get some data which is located on other server and oracle database?

1176

---

What is fill factor and pad index?

953

---

Does partitioning help performance?

888

---

How can I add Reporting Services reports to my application?

125

---