What are constraints? Explain different types of
constraints?

Answer Posted / hari

Constraint : To Restrict the voilation of irrelegular data
and maintain data integrity.

Primary key
Unique Key
NotNull
Forigen Key
Check

Is This Answer Correct ?    73 Yes 45 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1593


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

628


What are the types of joins in sql?

633


What is the difference between primary key and unique constraints?

568


How will you know when statistics on a table are obsolete?

680






What do you mean by data manipulation language?

655


What is raiseerror? What is raiseerror?

707


What is difference between joins and subqueries?

599


How to get the query of a table in sql server?

559


What is the difference between cartesian product and cross join?

555


How to create indexed view?

628


What is the purpose of object explorer and its features? : sql server management studio

685


Is sql server is free?

610


Mention the differences between sql server and mysql.

561


Explain optimistic and pessimistic concurrency?

604