Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 57 of 57

Marks: +1, -0

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, MAX(last_name), SUM(salary) FROM employees GROUP BY dept_id;
SELECT dept_id, LENGTH(last_name), SUM(salary) FROM employees GROUP BY dept_id;

Go to Question:

Prev Question