What is an Integrity Constraint?
Answers were Sorted based on User's Feedback
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 |
Integrity Constraint is a rule that restricts a value to a
clomn in table.
Is This Answer Correct ? | 2 Yes | 0 No |
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 |
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 |
What is the syntax and use of the coalesce function?
What is having clause in sql?
Enlist some predefined exceptions?
How to display Row Number with Records in Oracle SQL Plus?
What is Overloading of procedures ?
What is composite data type in pl sql?
How many developers work on postgresql?
what is row? : Sql dba
what is the bond code in materialized view?
IF i write before / after insert / update trigger and i do rollback what will happen?
How much ram can sql express use?
Does sql*plus also have a pl/sql engine?