Select __________ from instructor where dept name= Comp. Sci. ;Which – McqOptions

MCQOPTIONS

1.	Select __________ from instructor where dept name= Comp. Sci. ; Which of the following should be used to find the mean of the salary?
A.	Mean(salary)
B.	Avg(salary)
C.	Sum(salary)
D.	Count(salary)
Answer» C. Sum(salary)

Discussion

No Comment Found

Related MCQs

Select * from student join takes using (ID);<br>The above query is equivalent to ____________
Select ID, name, dept name, salary * 1.1 where instructor;<br>The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
Select ________ dept_name from instructor;<br>Here which of the following displays the unique values of the column?
Select ID, GPA from student grades order by GPA ____________<br>Inorder to give only 10 rank on the whole we should use.
Select __________ from instructor where dept name= Comp. Sci. ;<br>Which of the following should be used to find the mean of the salary?