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 |
explain advantages of innodb over myisam. : Sql dba
How to create a menu in sqlplus or pl/sql?
Why do we need unique key in a table?
Is there a 64 bit version of ssms?
Why commit is not used in triggers?
what is overloading procedure or overloading function ?
how can we repair a mysql table? : Sql dba
Why do we use partitions in sql?
25.67,-1 Trunc = 20 Round= 30 HOW????
what is the functionality of the function htmlentities? : Sql dba
What are different clauses used in sql?
What are the various levels of constraints?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)