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
Mention what are the benefits of pl/sql packages?
How to use sql statements in pl/sql?
What is the difference between null value, zero, and blank space?
Explain the purpose of %type and %rowtype data types with the example?
What is package in pl sql with an examples?
What is query optimization in sql?
Is sql a programming?
Why we use join in sql?
Where is all the data on the internet stored?
What are the key differences between SQL and PL SQL?
What is pl/sql table? Why is it used?
What is the use of prepared statement?
What is int identity in sql?
What is where clause in sql?
Can we change the table name in sql?