What is an Integrity Constraint?

Answers were Sorted based on User's Feedback



What is an Integrity Constraint?..

Answer / 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

What is an Integrity Constraint?..

Answer / suresh somayajula

Integrity Constraint is a rule that restricts a value to a
clomn in table.

Is This Answer Correct ?    2 Yes 0 No

What is an Integrity Constraint?..

Answer / pnc

A rule or restriction to maintain the accuracy of data or
quality of the data.

Is This Answer Correct ?    1 Yes 0 No

What is an Integrity Constraint?..

Answer / rajesh

Integrity Constraints prevent invalid data entry into the
table.These constraints set a range and any violation takes
place oracle prevent the user from performing manipulation
on the table.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the syntax and use of the coalesce function?

0 Answers  


What is having clause in sql?

0 Answers  


Enlist some predefined exceptions?

0 Answers  


How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,


What is Overloading of procedures ?

2 Answers  






What is composite data type in pl sql?

0 Answers  


How many developers work on postgresql?

0 Answers  


what is row? : Sql dba

0 Answers  


what is the bond code in materialized view?

0 Answers  


IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,


How much ram can sql express use?

0 Answers  


Does sql*plus also have a pl/sql engine?

0 Answers  


Categories