What are constraints? Explain different types of
constraints?

Answer Posted / wishpreet kaur

constraints are the restictions or boundaries.
we can categorise the constraints into 3 categories:
1. object constraints: specify that some objects depends
entirely or partially on other objects.
2. dynamic constraints: specify relationship among states
and events.
3. functional constraints: specify relationship among
operations.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain an automatic checkpoint

567


what is the difference between openrowset and openquery?

589


How is foreign key related to primary key?

578


Name few endpoints exposed by ssrs 2012?

305


How to encrypt Strored Procedure in SQL SERVER?

562






What is CTE in SQL

546


Why should you use or avoid select * statements?

579


What are rest-style architecture's?

149


What is ddl and dml commands?

516


What are the 7 disadvantages to a manual system?

516


Explain different types of Normalization.

601


How to test values returned by a subquery with the in operator?

677


How do you rename a table in sql server?

496


Can you create a logon trigger in sql server 2005 express edition?

579


Do you know what are various aggregate functions that are available?

529