Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are constraints? Explain different types of
constraints?

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

More SQL Server Interview Questions

How to add more data to the testing table in ms sql server?

0 Answers  


What is a field in a table?

0 Answers  


How and why use sql server?

0 Answers  


what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,


How do I find information about the install locations for the various instances running on a computer?

0 Answers  


What is logshipping and its purpose?

0 Answers  


What you can do to delete a table without the delete trigger firing?

0 Answers  


Difference between DELETE and TRUNCATE?

0 Answers   TCS,


Can you explain what are commit and rollback in sql?

0 Answers  


What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,


The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

0 Answers  


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  


Categories