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.

Describe and explain about SQL native client?

1159

---

What are the basic features of a trigger in ms sql server?

1269

---

Explain the properties of a relational table?

1079

---

what is the difference between delete table and truncate table commands? : Sql server database administration

1081

---

What is the difference between ddl,dml and dcl commands?

1161

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1102

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1116

---

What is stretch database in sql server?

1121

---

What is ms sql server index?

1153

---

What is service broker? : sql server database administration

1032

---

What are different types of database indexes?

1171

---

how to trace the traffic hitting a sql server? : Sql server database administration

1957

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1062

---

What happens if null values are involved in arithmetic operations?

1050

---

What is the difference between substr and charindex in the sql server?

1188

---