What is an Integrity Constraint?

Answer Posted / guest

integrity Constraints is used by oracle to check data
Integrity while performing operations into database.
Like columns is defined as not null.User cannot insert null
values into this column

Constraints:
1. Primary Key
2. Unique Key
3. Not Null
4. Referential Integrity(Foreign Key)
5.Check Constraints

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I tell if sql is running?

586


What is the use of sql trace?

479


What are pl sql procedures?

516


How do you create a unique index?

573


What is graph sql?

526






How to avoid using cursors? What to use instead of cursor and in what cases to do so?

601


Is delete faster than truncate?

547


What are the built in functions of sql?

565


How delete all data from table in sql?

573


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2005


how to escape special characters in sql statements? : Sql dba

513


What are the benefits of pl/sql packages?

541


What is a database trigger?

612


What is on delete restrict?

538


what are the properties and different types of sub-queries? : Sql dba

506