ORA-00907: Missing right parenthesis
Parentheses are unbalanced, or something inside them is not allowed there: for example a data type with a wrong size, or ORDER BY inside a subquery used with IN.
On the exam
This error belongs to the topic Basic SELECT 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.