Answer / prasanthi

Check Constraint:

The CHECK constraint is used to limit the value range that
can be placed in a column.

not null constraint:

if we give not null constraint to any column it will not
accept null values.

Unique Conatraint:

Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.

Answer / chaitu

These are contraints

What is normalization of database? What are its benefits?

0 Answers  

---

Is trigger fired implicitely?

2 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

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

0 Answers  

---

What is database dimension? : sql server analysis services, ssas

0 Answers  

---

What is row_number function?

0 Answers  

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

Can we use max in where clause?

0 Answers  

---

What is a functions and types in sql server?

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

How to resolve the orphan use problem? : sql server security

0 Answers  

---

what are different types of raid configurations? : Sql server database administration

0 Answers  

---