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 purpose of update command in oracle?
What do you understand by pl/sql records?
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
Why do we use subquery?
Is pl sql still used?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What are inner outer left and right joins in sql?
Differentiate between pl/sql and sql?
What is use of term?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
What is difference between function and trigger?
Can we call dml statement in function?