📝 Question
#1232
If a person all the people in Music department gets fired which of the following has to be performed on the instructor relation ?
✓
Correct Answer
D. All of the mentioned
💡
Explanation
Delete from table_name where condition . 6. SELECT DISTINCT T.name FROM instructor AS T, instructor AS S WHERE T.salary > S.salary AND S.dept name = ’Comp.Sci.’; a) Hayley b) Jackson c) Hayley and Crick d) Crick Only the greatest salary in Comp.Sci dept is selected for the query.
⌨️ Press
A
B
C
D
to select