ALLInterview.com :: Home Page KalAajKal.com
 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 ?    24 Yes 7 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 ?    8 Yes 8 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 ?    15 Yes 3 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 ?    9 Yes 4 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 ?    3 Yes 9 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 ?    4 Yes 0 No
Mangesh
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what is differece between union and union all  4
How do you troubleshoot SQL Server if its running very slow?  2
create index a on employee(dno) In this,which index was created?  2
Accidentally i deleted my table. How can i get that table?  4
what is a cursor and what is its use?  1
explain different types of jions with examples briefly? Zensar3
Display a roll having miminum marks in two subjects? Patni7
What are the types of backup and tell me the difference between full and differential backup? TCS3
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... TVS2
Which system tables contain information on privileges granted and privileges obtained  1
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj IBM7
What is a Trace frag?Where can we use this?  1
Can you explain the types of Joins that we can have with Sql Server?  2
What is an index? Yardi-Software7
can you any body tell me the how to decrease the logfile  4
What is the difference between UNION and UNIONALL? CTS2
What value could be assigned to Varchar Type?  3
Can Somebody tell me the difference between Clustered & Non- Clustered Index?? Progressive3
What are the advantages of using sql server over ms access or why should one use sql instead of ms access Impetus1
What is the diff between Dynamic queries and static queries ICS-Integrated-Computer-Solutions1
 
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 © 2007  ALLInterview.com.  All Rights Reserved.

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