Answer / 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.

Answer / surya

Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..

Answer / anand

primary constraint
check constraint
notnull constraint
foreign key constraint

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

What are the properties of primary key?

0 Answers  

---

How do triggers work?

0 Answers  

---

What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,

---

Explain sql delete command?

0 Answers  

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---

What are a scheduled jobs?

0 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

Psudo colums

1 Answers   HP,

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---