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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 ?    36 Yes 9 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 ?    13 Yes 11 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 ?    24 Yes 5 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 ?    15 Yes 8 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 16 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 ?    6 Yes 4 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 ?    2 Yes 2 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 ?    0 Yes 4 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 ?    2 Yes 0 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 ?    0 Yes 0 No
Annie Choudhary
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Which TCP/IP port does SQL Server run on?  2
What is Deadlock? Satyam3
which one will take 1st priority in case of insert statement and select statement???  2
what is the output for this query select * from employee where 1=1;  4
As a part of your job, what are the DBCC commands that you commonly use for database maintenance? HCL1
How do you fine the performance tunning? Accenture2
How to determine the service pack currently installed on SQL Server? HCL4
What is the difference between Userdefined function and stored procedure? Explain and give the example also  4
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?  1
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me. 247Customer2
What is a view? is View updatable? IBM12
What is the difference between 2-Tier architecture and 3-Tier architecture Oracle11
How to Get the last identity value used  4
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all) McAfee5
What does it mean to have quoted_identifier on? What are the implications of having it off?  2
What are the different types of replication? How are they used?  3
Difference between Function and Procedure-in general?  4
Explain the architecture of SQL Server?  2
How the data stores in a page?  1
 
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