ALLInterview.com :: Home Page
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
   
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What are constraints? Explain different types of 
constraints?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 1
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.
 
Is This Answer Correct ?    178 Yes 34 No
Haritha
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 2
Including these it also contains check constraint.
check constraint:-It specifies a range of values witn in 
which the attribute should take
 
Is This Answer Correct ?    70 Yes 29 No
Haritha
 
 
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 3
Constraints are the constraints which can provide on the 
column data.The types of constraints are
1).Domain Integrity constraints
EX:Check
2).Entity Integrity constraints
Ex:Unique,Primary key
3).Referential Integrity constraints
EX:Foreignkey
 
Is This Answer Correct ?    77 Yes 24 No
Satyanarayana
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 4
Constraint : To Restrict the voilation of irrelegular data 
and maintain data integrity.

Primary key
Unique Key
NotNull
Forigen Key
Check
 
Is This Answer Correct ?    54 Yes 26 No
Hari
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 5
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 ?    11 Yes 48 No
Napster Da Boss
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 6
. Primary Key Constraint
. Foreign Key Constraint
. Unique Key Constraint
. Check Constraint
 
Is This Answer Correct ?    24 Yes 20 No
Mangesh
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 7
Constraint mostly restrict the user from entering violated 
data into the table..

Various types of constraints are:
Primary Key Constraint
Foreign Key Constraint
Unique key Constraint
Check Constraint
NOT NULL Constraint
 
Is This Answer Correct ?    25 Yes 10 No
Smita
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 8
there are two types of 
constraints                                                 
1;holonomic 
constraint                                                  
2;non-holonomic constraints
 
Is This Answer Correct ?    12 Yes 41 No
Mohib
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 9
3 basic types
1.entity constraint:
check
not null
null
2.domain constraint:
unique
primary
composite primary key
3.referential constraint:
integrity
foreign
 
Is This Answer Correct ?    19 Yes 13 No
Rev
 
  Re: What are constraints? Explain different types of constraints?
Answer
# 10
Constraints are things that are likely to go wrong. There 
are three types.
Time constraints
Legal constraints
Finacial constraints
 
Is This Answer Correct ?    12 Yes 29 No
Annie Choudhary
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
how to select a field with firstletter as capital and remaining are small letters  10
How to change location of errorlog in SQL? IBM1
what is the disadvantage of SQL Loder? TCS1
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... TVS2
If we shrink the Databse and Files, how much size is decreased? TCS1
What are the types of indexes available with SQL Server? Standard-Bank2
How to connect PK and FK?  2
How do you read transaction logs  1
How do you load large data to the SQL server database?  2
How to know whether our backup is succesfully taken?  1
What are constraints? Explain different types of constraints? Polaris23
What are Magic Table? Evalueserve34
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2010  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com