What is a constraint. Types of constraints ?
Answer Posted / samuvel
Constraint is a restriction on table
Types:
1)Column Constraints:applicable for column level
i)unique ii) not null
2)Table constraints:applicable for table level
1)primary key ii) foreign key d. check
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
what are date and time intervals? : Sql dba
What is break?
What is function and procedure in pl sql?
what does myisamchk do? : Sql dba
How to avoid duplicate records in a query?
Which is better join or inner query?
What are basic techniques of indexing?
What is data definition language?
What is the use of nvl function?
What is $$ in sql?
What is sqlservr exe?
Explain the significance of the & and && operators in pl sql.
Are dml statements autocommit?
Show how functions and procedures are called in a pl/sql block.
What do you understand by pl/sql cursors?