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 ?    26 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 ?    9 Yes 9 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 ?    16 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 ?    11 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 the difference between IN and EXISTS operators in SQL Server? Intelligroup3
can you any body tell me the difference between candidate key and primary key  4
Can we create a clustered index on composite primary key.  2
What are different types of Keys? Please explain all the keys with a suitable example.  2
How do you check the performance of a query and how do you optimize it?  1
What is the order in which the SQL query is executed? list them in order. CTS1
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"  6
Which virtual table does a trigger use? TCS6
What is the purpose of UPDATE STATISTICS?  1
how can do you the system monitoring?  1
What are Magic Table? Evalueserve15
Can you explain the types of Joins that we can have with Sql Server?  2
How do you read transaction logs  1
What is Files and Filegroups in SQL Server & it's implementation. Zenith1
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
can you any body tell me the how to decrease the logfile  4
What are primary keys and foreign keys?  3
Wht is the difference between stored procedure and trigger TCS4
write the query for taking database backup in sql Logica-CMG6
how to dispaly a particular row details from a given table  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