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 |
How do I run a program in pl sql?
What is Overloading of procedures ?
What is field delimiter?
What are the types of optimization?
Can we write create command in the plsql block?if possible how?
What are properties of the transaction?
What is a natural join?
What is the difference between delete and truncate statement in sql?
What is the difference between having and a where in sql?
what are the security recommendations while using mysql? : Sql dba
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
What is clustered, non-clustured and unique index. How many indexes can be created on a table ?
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)