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 |
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What are the uses of a database trigger?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
what are the things that you consider while creating indexes on partitioning tables?
Is oracle a programming language?
What privilege is needed for a user to create tables in oracle?
How to experiment a data lock in oracle?
How to define default values for formal parameters?
How to assign values to data fields in record variables?
can you explain performance tunning in oracle(sql,PL/SQL)