What are constraints? Explain different types of
constraints?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / rohit
MySQL does not support the use of CHECK constraint
Is This Answer Correct ? | 4 Yes | 12 No |
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 |
Answer / mohib
there are two types of
constraints
1;holonomic
constraint
2;non-holonomic constraints
Is This Answer Correct ? | 21 Yes | 58 No |
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 |
What are xml indexes?
why SQL server is more used to store database rather than Access
What is temporary table in sql server? Why we use temp table?
What are the different types of Indexes available in SQL Server?
What are page splits?
What is a subquery in a select query statement in ms sql server?
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?
What are the results of running this script?
What is key attribute?
What are the two authentication modes in sql server?
What is mssql?
What are the aggregate and scalar functions?