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

What are the type of Indexes? which one is best, why?

6 Answers  


can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  


your distribution database is full what will u do

0 Answers  


How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,






I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,


How to find 6th highest salary from Employee table ?

10 Answers  


what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,


What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,


How to handle errors in Stored Procedures.

2 Answers   Accenture,


how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  


How to find the last update record in SQL Server?

4 Answers  






Categories