If a person all the people in Music department gets fired which of the following has to be performed on the instructor relation ?
A. Delete Dept_name=Music in instructor;
B. Delete from instructor where Dept_name=Music;
C. Remove Dept_name= Music
D. All of the mentioned
Answer:A
If a person all the people in Music department gets fired which of the following has to be performed on the instructor relation ?
A. Delete Dept_name=Music in instructor; B. Delete from instructor where Dept_name=Music; C. Remove Dept_name= Music D. All of the mentioned
Explanation:Delete from table_name where condition .