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 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 ?    326 Yes 56 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 ?    218 Yes 29 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 ?    105 Yes 32 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 ?    46 Yes 63 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 ?    92 Yes 23 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 ?    42 Yes 10 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 ?    46 Yes 13 No
Yashwanth
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 8
constraint is a mechanism it is used to prevent the invalid
data entry in to the table is called constraint
 
Is This Answer Correct ?    42 Yes 9 No
Bose
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 9
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 ?    27 Yes 13 No
Srinivas
 
  Re: what is Constraint? How many types of constraints in SQL ?
Answer
# 10
Constraints are rool of data integrity.

Types of Constraints are:
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References.
 
Is This Answer Correct ?    38 Yes 11 No
Vijaya
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
how do we insert 100 records at a time in a table without using for loop in database   1
How can u convert the Date to String? TCS 6
What is the difference between login and a user? TCS 12
what is meant by deafult in sql server?   2
CTE(common table expression) Thomson-Reuters 1
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder IBM 3
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes.. Rolta 15
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 IBM 9
how can ur insert the emp table Wipro 3
what is the order of execution of where,having,group by in select stement Tanla-Solutions 6
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??   2
What are the types of indexes available with SQL Server? Standard-Bank 2
 
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