Oracle Discussions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Go to Exam

Exam 1z0-071 topic 1 question 191 discussion

Actual exam question from Oracle's 1z0-071

Question #: 191
Topic #: 1

[All 1z0-071 Questions]

Examine this data in the EMPLOYEES table:

Which statement will execute successfully?

A. SELECT dept_id, INSTR(last_name, ‘A’), SUM(salary) FROM employees GROUP BY dept_id;
B. SELECT dept_id, STDDEV(last_name), SUM(salary) FROM employees GROUP BY dept_id;
C. SELECT dept_id, LENGTH(last_name), SUM(salary) FROM employees GROUP BY dept_id;
D. SELECT dept_id, MAX(last_name), SUM(salary) FROM employees GROUP BY dept_id;

Show Suggested Answer

Suggested Answer: D 🗳️

by jfc1 at Feb. 16, 2023, 4:42 p.m.

Comments

Submit Cancel

yaya32

12 months ago

Selected Answer: D

D is correct

upvoted 2 times

...

Arth1989

1 year ago

Admins, why so many questions are marked incorrectly?

upvoted 2 times

...

lucemqy

1 year, 2 months ago

Selected Answer: D

D should be the correct answer

upvoted 1 times

...

zouve

1 year, 6 months ago

D tested

upvoted 1 times

...

Rik92

1 year, 8 months ago

Selected Answer: D

D is correct

upvoted 1 times

...

Darnun

1 year, 9 months ago

Selected Answer: D

D correct answer

upvoted 1 times

...

alic_alex

1 year, 10 months ago

Selected Answer: D

D correct

upvoted 1 times

...

jfc1

1 year, 11 months ago

Selected Answer: D

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

upvoted 2 times

...