explain the type of contraints




Answers were Sorted based on User's Feedback



explain the type of contraints..

Answer / reva ram sahu

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 ?    4 Yes 0 No

explain the type of contraints..

Answer / surya

Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..

Is This Answer Correct ?    3 Yes 0 No

explain the type of contraints..

Answer / anand

primary constraint
check constraint
notnull constraint
foreign key constraint

Is This Answer Correct ?    0 Yes 1 No



Post New Answer



More SQL Server Interview Questions

Which stored procedure will you be running to add a linked server?

1 Answers  


How do SQL server 2000 and XML linked?

2 Answers  


Differnce between sel server 2000 and 2005

3 Answers  


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  


What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,






What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   CSC, Intelligroup, ASD Lab,


What are constraints? Explain different types of constraints?

26 Answers   Wipro, Polaris, Kendriya Vidyalaya(Kvs), Emsang,


What is the use of CASCADE CONSTRAINTS?

3 Answers  


Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  


WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  


What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  


WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,






Categories