ISRO CS-2023
August 29, 2024ISRO CS-2023
August 29, 2024ISRO CS-2023
|
Question 28
|
Which of the following SQL query deletes all tuples in the teacher relation for those teachers associated with a department located in the building with name CSE and which is in department relation:
|
DELETE FROM teacher WHERE dept_name IN ‘CSE’;
|
|
|
DELETE FROM department WHERE building-‘CSE’;
|
|
|
DELETE FROM teacher WHERE dept_name IN (SELECT dept_name FROM department WHERE building = ‘CSE);
|
|
|
None of the above
|
Correct Answer: C