ORA-00979: Not a GROUP BY expression
Every expression in the SELECT list (and in HAVING and ORDER BY) that is not inside a group function must appear in GROUP BY. Oracle never picks an arbitrary value for you.
On the exam
This error belongs to the topic Aggregation of exam 1Z0-071.
In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.