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
Subscribe
Login
0 Comments