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                      
Google
   
 
Categories >> Software >> Databases >> SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions (2035)
 SQL Server interview questions  SQL Server Interview Questions (1075)
 MS Access interview questions  MS Access Interview Questions (24)
 MySQL interview questions  MySQL Interview Questions (194)
 Postgre interview questions  Postgre Interview Questions (6)
 Sybase interview questions  Sybase Interview Questions (22)
 DB Architecture interview questions  DB Architecture Interview Questions (5)
 DB Administration interview questions  DB Administration Interview Questions (213)
 DB Development interview questions  DB Development Interview Questions (53)
 SQL PLSQL interview questions  SQL PLSQL Interview Questions (768)
 Databases AllOther interview questions  Databases AllOther Interview Questions (106)
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 ?    234 Yes 52 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 ?    92 Yes 37 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 ?    106 Yes 34 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 ?    65 Yes 37 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 ?    15 Yes 64 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 ?    36 Yes 25 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 ?    37 Yes 18 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 ?    20 Yes 57 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 ?    26 Yes 21 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 ?    15 Yes 48 No
Annie Choudhary
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what is difference between nchar and char in Sql server ?   3
How many types of cursors are there in SQL Server? 247Customer 5
What are constraints? Explain different types of constraints? Polaris 25
How will u get 5 years back record?   5
What is difference between restoration and recovery in SQLServer? Microsoft 3
how to retrive only second row from table in sql server 2000? CTS 15
What is the use of SCOPE_IDENTITY() function?   2
how many type of subquery?   2
What is Stored Procedure? What is Views in sql server? Difference between a User Defined Function and a Stored Procedure Difference between a primary key and a unique key? What is a join and explain different types of joins. Difference between temp table and table variable Difference between Triggers and Stored Procedures Difference between UNION ALL Statement and UNION What is COALESCE / Why do we use COALESCE? Why we use SET ROWCOUNT in Sql How many clustered index can have a table How many types of local tables in SQL SERVER Difference between DELETE and TRUNCATE What is Aggregate Functions? What is Row_Number()? What are Ranking Functions? What is NOLOCK? What is CTE? What are the Advantages of using CTE? What is the STUFF function and how does it differ from the REPLACE function? What are the difference between clustered and a non-clustered index? What are the different index configurations a table can have? Difference between a HAVING CLAUSE and a WHERE CLAUSE? Difference between SET and SELECT Provide all the built in string function of SQL SERVER Difference between char and varchar data types Define candidate key, alternate key, composite key. What are constraints? Explain different types of constraints. What is a self join? Explain it with an example. How will you convert table row to a column comma separated value ACS 4
what is diffence between replicaion and logshipping?   1
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??   8
What are cursors? Name four types of cursors and when each one would be applied? Adea-Solutions 3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com