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 the command used to fetch the first 5 characters of a string?
How to add a column ‘salary’ to a table employee_details?
What is the difference between local variables and global variables?
What are the types of functions in sql?
What is bulk compiling in pl/sql.?
What are some predefined exceptions in pl/sql?
What is self-join and what is the requirement of self-join?
Is not equal in sql?
Explain clause in sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is a stored procedure in sql with example?
What are all the different normalization?
What is program debugging?
What is restrict in sql?
What are the different types of dbms?
