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   To Refer this Site to Your Friends   Click Here
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 is Constraint? How many types of constraints in SQL ?
 Question Submitted By :: Indra
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 1
Constraint are the rules enforced on data columns on table.

Five type of constraints 
Primary key
Unique Key
Foreign Key
Not Null
Check
 
Is This Answer Correct ?    47 Yes 9 No
Mudit
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 2
Constraints are used to limit the type of data that can go 
into a table.

NOT NULL 
UNIQUE 
PRIMARY KEY 
FOREIGN KEY 
CHECK 
DEFAULT
 
Is This Answer Correct ?    21 Yes 7 No
Scornguy
 
 
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 3
Constraint are the rules enforced on data columns on table

types of constraints:

PRIMARYKEY
FOREIGN KEY 
NOT NULL
UNIQUE KEY
CHECK 
DEFAULT
Check
 
Is This Answer Correct ?    10 Yes 5 No
Kumari
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 4
Constraints are the way by Databse managing the data inegrity.

Types of constraint are:-
1)NOT Null
2)Default
3)Check
4)Rule
5)Primary
6)Unique
7)Foreign
 
Is This Answer Correct ?    3 Yes 9 No
Lekhraj
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 5
Constraints are used to limit the type of data that can go 
into a table.
 two basic types of constraints are there 
1.column level
2.table level
the difference is that column level constraints are apply
only to one column where as table level constraints are
apply to whole table 
Constraints are declare at the time of table creation using
CREATE TABLE command 

there are 6 constraints used in oracle
1.NOT NULL
2.UNIQUE
3.PRIMARY KEY
4.CHECK
5.DEFAULT
6.REFERENCES
 
Is This Answer Correct ?    13 Yes 3 No
Bimaleswar Patel
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 6
Constraint are used to  table columns validations.
there are some constraints.

Primary key,
Foreign Key,
Not Null,
Check,
Unique Key,
default
 
Is This Answer Correct ?    3 Yes 0 No
Shankar K
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 7
constraints are the rules enforced on data columns on a 
table
 use:constraints are used to limit the type of data that 
can go in to a table

there are some constraints
a primarykey constraint
a unquekey constraint
a foreinkey constraint
a check constraint 
a not null constraint
a default constraint
 
Is This Answer Correct ?    2 Yes 1 No
Yashwanth
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to get the count of distinct records. Please give me the query? Value-Labs5
wat is the main diff between sql server 2000and sql server 2005 Jade-Software6
How do we get month name in SQL Server 2000, Oracle, MS Access?  9
how to select a field with firstletter as capital and remaining are small letters  8
Can some one please help with a query which will take only max value of a column in a join.  2
how many type of subquery?  2
What are the types of indexes available with SQL Server?  2
What is mean by "fill factor" ? and what is mean by "Index "in sql? Logica-CMG1
what are default? Is there a column to which a default cant be bound?  1
How can you get @@error and @@rowcount at the same time?  5
What are the type of joins? When do we use Outer and Self joins?  3
How do we get current date in SQL Server 2000, Oracle, MS Access?  11
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.  7
What is the role that is required for killing a process What is the role that is required for creating a linked server IBM1
How can you see what type of locks used?  1
How m-m relationships are implemented?  1
How do you check the performance of a query and how do you optimize it?  1
What is a table called, if it does not have neither Cluster nor Non-cluster Index?  1
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?  1
how can we use a composite key for two tables and how can we represent it BoA1
 
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