What is an Integrity Constrains ?
Answers were Sorted based on User's Feedback
Answer / din dayal singh
Integrity constraints are used to ensure accuracy and
consistency of data in a relational database.[citation
needed] Data integrity is handled in a relational database
through the concept of referential integrity. There are many
types of integrity constraints that play a role in
referential integrity.
Entity integrity
Referential Integrity
Domain Integrity
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
Integrity constraints provide a way of ensuring that changes made to the database by authorized users do not result in a loss of data consistency.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / deva
Primary key and unique key constraints are known as
integrity constraints where they are supposed to check the
unique of the records.
| Is This Answer Correct ? | 0 Yes | 2 No |
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
Explain the use of owner option in exp command.
What is the sql query to concatenate column values from multiple rows in oracle?
How to recover a dropped index?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
How to view the data files in the current database?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to delete multiple rows from a table in oracle?
Explain index?
What is the difference between alert log file and trace file ?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.