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 is audit logout in sql profiler?
what is cursor. write example of it. What are the attributes of cursor.
What are the sql aggregate functions?
Can you have a foreign key without a primary key?
what is oltp (online transaction processing)? : Sql dba
How do you respond to dementia behavior?
Can we create table in function?
how can we know the count/number of elements of an array? : Sql dba
Why is sharding used?
what is a trigger? : Sql dba
What is sp_helptext?
What is sql mysql pl sql oracle?
Write an sql query to select all records from the table?
What is varray in pl sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?