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

What is the purpose of normalization?

754


What is crud diagram?

677


What is scalar and vector?

720


Write a sql query to convert all character to uppercase after hypen.

1167


How to use boolean type in select statement?

749






How do I run a script in sql developer?

703


What is the difference between rollback and rollback to statements?

806


How many joins in sql?

736


What does fetching a cursor do?

801


List out the acid properties and explain?

711


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

724


What is data control language?

736


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

739


What is difference between nchar and nvarchar?

695


What is a table in a database?

785