Vidyalelo
MySQL · Q1083

MySQL

Programming · MySQL · question 1083

Q1083

What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

A.
transparent
B.
concrete
C.
elaborate
D.
cascaded
Answer

Answer: Option D

Solution

Answer: Option D
Solution:
Imagine you have two tables: one for "Employees" and another for "Projects".
Each employee can work on multiple projects.
Now, let's say you want to delete an employee from the "Employees" table.
A cascaded delete is like a domino effect. When you delete the employee, the database automatically deletes all the entries related to that employee in the "Projects" table.
So, the answer is Option D: cascaded.