Answer Posted / k.swathi

constraint is a mechanism which is used to stop the data entered by the end user by implementing bussiness rules.

contraint are 6 types
1)unique
2)primary key
3)check
4)null
5)not null
6)foreign key(refferential key)

How to Check if table exists in sql server?

1075

---

Describe how to use the linked server?

1066

---

How to get a list of all tables with "sys.tables" view in ms sql server?

984

---

What is database mirroring?

1041

---

Do you know what are the differences between lost updates and uncommitted dependencies?

1010

---

Do you know sql server 2008 introduces automatic auditing?

915

---

What happens if you delete a table that is used by a view?

944

---

How to perform key word search in tables?

914

---

Can group by be used without aggregate functions?

857

---

What are drilldown reports?

140

---

Explain different types of collation sensitivity?

926

---

Explain the properties of sub-query in sql server?

956

---

What is a cube? : sql server analysis services, ssas

947

---

what are defaults? : Sql server database administration

1008

---

What do you understand by SQL*Net?

960

---