What is a constraint. Types of constraints ?
Answer Posted / pavani
Constraint means it is rule which you want to apply on the
table. There are two types of constraints.
1. Column Constraints: Applicable for that column only.
2. Table Constraints: Applicable for more than one column.
Column Constraints:
a. unique b. not null c. primary key d. foreign key
e.default f. check
Table constraints:
a. unique b. primary key c. foreign key d. check
| Is This Answer Correct ? | 26 Yes | 5 No |
Post New Answer View All Answers
Where not exists in sql?
What are sql constraints?
Is sql workbench free?
What is a file delimiter?
How would you convert date into julian date format?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Explain the types of joins in sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How do I create a sql script?
When is a declare statement required?
What are the key differences between SQL and PL SQL?
Are subqueries faster than joins?
How can you fetch common records from two tables?
What do you mean by rowid?
What is a primary key? Explain