Answer Posted / haritha

constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.

Can you tell me some of the common replication dmv's and their use? : sql server replication

917

---

What do you understand by replication in sql server?

1055

---

What is the name of the Database which IBM mainframe uses?

976

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1502

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1101

---

How many databases instances are there in sql server 2000?

1091

---

What are the different acid properties?

1057

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1016

---

What is a non-clustered index?

991

---

What is the report model project?

141

---

What are different types of schemas?

938

---

What is coalesce in sql server?

1048

---

What is checkpoint in sql server?

1130

---

how can you attach more than 20 ldf files in sql server

1992

---

Explain the commands in sql server?

1033

---