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

Why do we use view in sql?

530


What language is oracle sql developer?

506


what are date and time data types? : Sql dba

532


What is the difference between left and left outer join?

511


explain advantages of innodb over myisam. : Sql dba

638






what are enums used for in mysql? : Sql dba

604


What is bind variable in pl sql?

520


What is the usage of the distinct keyword?

682


Explain the working of foreign key?

540


How do I make my sql query run faster?

462


Does execute immediate commit?

693


Explain about various levels of constraint.

517


Why commit is not used in triggers?

574


i have some prob lem to tell me about my self in interview first round ...

1698


How to write pl sql program in mysql command prompt?

509