What is a constraint. Types of constraints ?

Answer Posted / sujit.1551

constraint are nothing but a conditions,in other words
enforcing the business rules into the database.
types of constraits:
1)check constraint
2)unique constraint
3)primary key
4)foreign key
5)Not null
6)Default

Is This Answer Correct ?    20 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the dml statements?

853


Can we call dml statement in function?

765


what is the syntax for using sql_variant_property? : Transact sql

704


Explain about various levels of constraint.

700


What is Collation Sensitivity ? What are the various type ?

697






What is memory optimized table?

762


What is primary key and unique key?

760


What is the difference between having and a where in sql?

799


Why do we use sqlite?

707


What is varchar used for?

750


How to know the last executed procedure?

809


How many scalar data types are supported in pl/sql?

714


Explain the difference between sql and mysql.

753


Does inner join remove duplicates?

699


What is multiple columns?

777