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 does bitemporal mean?

0 Answers  


What is error ora-01000: maximum open cursors exceeded

0 Answers  


What is the difference between a query and a report?

0 Answers  


What is a database trigger?

0 Answers  


how many triggers are allowed in mysql table? : Sql dba

0 Answers  






what is indexing, searching and user interface?

1 Answers   HCL,


can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,


Can you alter start with clause?

1 Answers   TCS,


Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,


Can I create table without primary key?

0 Answers  


What is sqlservr exe?

0 Answers  


What is mutating error in pl sql?

0 Answers  


Categories