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
- 7772 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
How do you ensure database security?
Difference between cartesian join and cross join?
What is a View ?
When system tablespace is created?
What is SQL access advisor in Oracle?
How many categories of data types in oracle?
sql query to get zero records from a table
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are the ansi data types supported in oracle?
what are bitmap indexes? How does they work?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Oracle General 
