Which Of The Following Deletes All Tuples In The Instructor #306

Which of the following deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation.

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Modification of Database - Quiz No.1.

 Delete from instructor where dept_name in 'Watson';

 Delete from department where building='Watson'; 

 Delete from instructor where dept_name in (select dept name from department where building = ’Watson’);