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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion