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
What is a null value?
What are the differences between in and exists clause?
What is clustered index sql?
What are the parameter modes supported by pl/sql?
Why do we use subquery?
Can delete statement be rollbacked?
What is full form of rtm?
Is sql database free?
What is difference between stored procedure and trigger?
What is replication id?
What is the difference between nvl function, ifnull function, and isnull function?
What is sql rowcount?
What is output spooling in sql*plus?
How does sql*loader handles newline characters in a record? : aql loader
What do you understand by case manipulation functions?