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

How do I perform an unattended install of sql server 2000?

1070

---

What is the difference between stored procedure and functions?

1115

---

How many instances per computer are there in sql server 2000?

1054

---

Explain sql server authentication modes?

1119

---

Can a database be shrunk with users active?

1116

---

What is log shipping?

954

---

A trigger can reference objects outside the current database? State true or false.

999

---

What happens when converting big values to integers?

992

---

What is sql or structured query language?

1138

---

Tell me what is the stuff and how does it differ from the replace function?

976

---

How to change the ownership of a schema in ms sql server?

1174

---

How do I delete a sql server database?

1033

---

If no size is defined while creating the database, what size will the database have?

978

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1793

---

How can i Relate Tables in SSIS

1073

---