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

What is a null value?

659


What are the differences between in and exists clause?

571


What is clustered index sql?

506


What are the parameter modes supported by pl/sql?

536


Why do we use subquery?

489






Can delete statement be rollbacked?

527


What is full form of rtm?

535


Is sql database free?

533


What is difference between stored procedure and trigger?

537


What is replication id?

524


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

593


What is sql rowcount?

559


What is output spooling in sql*plus?

553


How does sql*loader handles newline characters in a record? : aql loader

588


What do you understand by case manipulation functions?

547