Answer Posted / aravindu chowdary

CONSTRAINTS:
*It is a rule (or) restriction ,which is enforced during a
creation of table.
*constraints raises automatically at the time of
inertion,updation,deletion.
*constraints there are 3 types
1.Domain Integrity
* Not null:Donot allow null value.
* check: Limits the range of values or domain, checks
the values which a col can have
2.Entity Integrity
* Unique key:donot allow duplicate values, but allows
one null per col.Can have multiple unique constraints on a
table





* Primary key : Ensure no duplicate data and not allow
nulls.

3.Refrential Intrgrity
*Forgien key:Referntial integrity b/w 2 tables, one
table col values based on other table col values

What is the purpose of optimization?

1008

---

How does the report manager work in SSRS?

152

---

What languages bi uses to achieve the goal?

1012

---

How to concatenate two character strings together?

1130

---

What kind of problems occurs if we do not implement proper locking strategy?

1413

---

What is for xml in sql server?

1086

---

Is mysql the same as sql server?

999

---

Ms sql server index?

1070

---

what is difference between NULL and ISNULL in SQL Server 2008?

1025

---

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

1075

---

When a primary key constraint is included in a table, what other constraints does this imply?

994

---

Is INSTEAD OF trigger directly applicable to Table ?

1028

---

What are the different Topologies in which Replication can be configured?

1197

---

Explain features and concepts of analysis services?

989

---

What are partitioned views and distributed partitioned views?

1028

---