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 |
Will truncate release space?
How does postgresql compare to "nosql"?
what is d diff between grant,commit,rollback n savepoint
What is nested table in pl sql?
What is data type in sql?
what is a unique key ? : Sql dba
What is extent clause in table space?
Which is faster truncate or drop?
what is sql.
Explain about various levels of constraint.
display records from 5 to 9 using rowid or rownum
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
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)