Examveda

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: Option D

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous