Answer Posted / ansupriya
If child record exists user cannot delete parent record.
Using on delete cascade on foreign constraint user can delete parent record .
Same time automatically it will delete the child record.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are the advantages and disadvantages of cascading style sheets? : Sql dba
what is schema? : Sql dba
Explain how exception handling is done in advance pl/sql?
What is the difference between jpql and sql?
What is date functions?
How do you optimize a stored procedure in sql?
What is #table in sql?
What is coalesce sql?
Can we call stored procedure in function?
How can you select unique records from a table?
What are the key differences between SQL and PL SQL?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is a crud api?
What is difference between sql and mysql?
How to use distinct and count in sql query? Explain