Answer Posted / krishna

constraints are use to maintain the relation between the two tables. sql contains the 5 types of constraints
1.primary key
2.foreign key
3.unique key
4.Not null
5.check

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1075

---

What is catalog views?

1068

---

What is the difference between Triggers and Stored Procedure?

1097

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

---

What is difference between index seek vs. Index scan?

1155

---

What are trace flags and mention a few common trace flags used with sql server?

1088

---

Explain hostprotectionattribute in sql server 2005?

1035

---

How many triggers you can have on a table?

996

---

What do you mean by the term 'normalization'?

1209

---

when you create a database how is it stored? : Sql server database administration

1025

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1158

---

What are the 7 disadvantages to a manual system?

984

---

What is the bookmark lookup and rid lookup?

998

---

Tell me what are the essential components of sql server service broker?

941

---

Explain the truncate command? : SQL Server Architecture

1173

---