Interested to Buy Any Domain ? << Click Here >> for more details...
Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ?
- 2 Answers
- 7763 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep desai
No.
Eg:-
Consider Table emp
Assume there are only 5 records in emp
and in emp_sal column values are (1200,1400,4500,2000).
Now if I try to create a check constraint on emp_sal column
for the range between 2000 and 4000 then an error is thrown
since values below this range also exist in emp_sal column.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain an integrity constrains?
What are the attributes of cursor?
definition of cluster and non-clustered index?
What is oracle update statement with inner join ?
Explain integrity constraint?
How to define a record variable to store a table row?
What is meant by joins? List out the types of joins.
Explain the use of parfile option in exp command.
How can you use check constraints for self referential integrity?
Explain a segment?
How to create a stored program unit?
How to revoke create session privilege from a user in oracle?
Is there a combination of "like" and "in" in sql?
How to create a single index for multiple columns?
Difference between pre-select and pre-query
