Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 183

Examine this data in the EMPLOYEES table:

Which statement will execute successfully?

SELECT dept_id, INSTR(last_name, ‘A’), SUM(salary) FROM employees GROUP BY dept_id;

SELECT dept_id, STDDEV(last_name), SUM(salary) FROM employees GROUP BY dept_id;

SELECT dept_id, LENGTH(last_name), SUM(salary) FROM employees GROUP BY dept_id;

SELECT dept_id, MAX(last_name), SUM(salary) FROM employees GROUP BY dept_id;

Correct Answer: D

The correct answer should involve only the grouped column and aggregate functions. Option D uses MAX(last_name), an aggregate function, and SUM(salary), another aggregate function, along with the grouped column dept_id. This is valid SQL syntax. Options A, B, and C reference non-aggregate functions (INSTR, STDDEV, and LENGTH respectively) without including them in the GROUP BY clause, which violates SQL grouping rules.

Discussion

yaya32Option: D

D is correct

jfc1Option: D

C is invalid and returns the error : ORA-00979: not a GROUP BY expression

Arth1989

Admins, why so many questions are marked incorrectly?

lucemqyOption: D

D should be the correct answer

zouveOption: D

D tested

Rik92Option: D

D is correct

DarnunOption: D

D correct answer

alic_alexOption: D

D correct