Answer Posted / reva ram sahu

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.

How to use “drop” keyword in sql server and give an example?

1131

---

Explain unique key in sql server?

1013

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

985

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

990

---

What does indexation mean?

974

---

What are the acid properties?

1005

---

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

1158

---

How to create a dynamic cursor with the dynamic option?

1047

---

What is ddl command?

983

---

How to how to convert numeric expression data types using the convert() function??

1052

---

Explain the different types of joins?

997

---

how you can configure a running aggregate in SSRS?

190

---

How can we solve concurrency problems?

1054

---

Sql server reporting services vs. Crystal reports.

132

---

What is an indexing strategy?

1010

---