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= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?

Question

TuteeHUB · Accepted Answer

Remove Dept_name= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3b) 4c) 2

TuteeHUB · Answer

Delete Dept_name=Music in instructor;b) Delete from instructor where Dept_name=Music;c) Remove Dept_name= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3

TuteeHUB · Answer

Delete from instructor where Dept_name=Music;c) Remove Dept_name= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3b) 4

TuteeHUB · Answer

Remove Dept_name= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3b) 4c) 2

TuteeHUB · Answer

All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3b) 4c) 2d) 1View Answer

1.	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= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?
A.	Delete Dept_name=Music in instructor;b) Delete from instructor where Dept_name=Music;c) Remove Dept_name= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3
B.	Delete from instructor where Dept_name=Music;c) Remove Dept_name= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3b) 4
C.	Remove Dept_name= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3b) 4c) 2
D.	All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3b) 4c) 2d) 1View Answer
Answer» C. Remove Dept_name= Musicd) All of the mentioned What will be displayed as the value of name for the above query?a) Hayleyb) Jacksonc) Hayley and Crickd) CrickView Answer How many rows are selected ?a) 3b) 4c) 2

Discussion

No Comment Found

Related MCQs

Reply to Comment