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 purpose of update command in oracle?

7 Answers   MBT,


What do you understand by pl/sql records?

0 Answers  


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.

4 Answers   Hexaware,


Why do we use subquery?

0 Answers  


Is pl sql still used?

0 Answers  






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

0 Answers  


What are inner outer left and right joins in sql?

0 Answers  


Differentiate between pl/sql and sql?

0 Answers  


What is use of term?

0 Answers  


What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  


What is difference between function and trigger?

0 Answers  


Can we call dml statement in function?

0 Answers  


Categories