What are constraints? Explain different types of constraints?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

What are constraints? Explain different types of
constraints?

Question Posted / guest

26 Answers
139413 Views
Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are constraints? Explain different types of constraints?..

Answer / aravindu chowdary

CONSTRAINTS:
*It is a rule (or) restriction ,which is enforced during a
creation of table.
*constraints raises automatically at the time of
inertion,updation,deletion.
*constraints there are 3 types
1.Domain Integrity
* Not null:Donot allow null value.
* check: Limits the range of values or domain, checks
the values which a col can have
2.Entity Integrity
* Unique key:donot allow duplicate values, but allows
one null per col.Can have multiple unique constraints on a
table

* Primary key : Ensure no duplicate data and not allow
nulls.

3.Refrential Intrgrity
*Forgien key:Referntial integrity b/w 2 tables, one
table col values based on other table col values

Is This Answer Correct ?

1 Yes

4 No

What are constraints? Explain different types of constraints?..

Answer / the smart one

constraint is something that is restricted or prohibited
for example.
1. Not driving with a license

2. partying after hours if 17 or younger.

Is This Answer Correct ?

2 Yes

6 No

What are constraints? Explain different types of constraints?..

Answer / rohit

MySQL does not support the use of CHECK constraint

Is This Answer Correct ?

4 Yes

12 No

What are constraints? Explain different types of constraints?..

Answer / annie choudhary

Constraints are things that are likely to go wrong. There
are three types.
Time constraints
Legal constraints
Finacial constraints

Is This Answer Correct ?

15 Yes

49 No

What are constraints? Explain different types of constraints?..

Answer / mohib

there are two types of
constraints
1;holonomic
constraint
2;non-holonomic constraints

Is This Answer Correct ?

21 Yes

58 No

What are constraints? Explain different types of constraints?..

Answer / napster da boss

these are the constarints or codes which an organisation
has to abide by. Not necessarily does any one have to abide
by these, however there are many biles like that can kinda
get peopel to abide by them u get me blud. Dun now this is
dab real macoy doe.
Vote YES for dis 1 if u r a real G u get me.
All ady everyday 2K8 get 2 know.

Is This Answer Correct ?

15 Yes

65 No

Post New Answer