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 plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  


explain about mysql and its features. : Sql dba

0 Answers  


In testing where do we use sql language and how it helps in testing?

2 Answers  


What is left inner join in sql?

0 Answers  


what is an index? : Sql dba

0 Answers  






What are the advantages of indexing?

0 Answers  


Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  


Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,


how mysql optimizes distinct? : Sql dba

0 Answers  


what is not null constraint? : Sql dba

0 Answers  


What is a Procedure ?

3 Answers  


how to shutdown mysql server? : Sql dba

0 Answers  


Categories