What is a constraint. Types of constraints ?

Answer Posted / sohail

Constraint is a restriction on table.There are two types of
constraints 1.ananymous constraint and 2.named
constraint.under named and ananymous constraints there are
1.primary key constraint
2.foreign key constraint
3. not null constraint
4. check constraint
5. unique constraint.

Is This Answer Correct ?    40 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which join is like inner join?

668


Can we use commit inside a trigger?

631


How to raise user-defined exception with custom sqlerrm ?

765


does sql support programming? : Sql dba

683


What is delimiter sql?

630






What is the difference between the conventional and direct path loader? : aql loader

750


Does a user_objects view have an entry for a trigger?

648


How long will it take to learn pl sql?

615


What is the difference between nvl function, ifnull function, and isnull function?

688


What is pl sql and why it is used for?

678


What are functions in sql?

580


What is lexical units in pl sql?

665


What are the types of operators available in sql?

668


What does the sign mean in sql?

605


What is left inner join in sql?

610