OCP CBT Question 652

Please solve the following question.

Examine the following query:

sqlSELECT first_name, last_name, commission_pctFROM employeesWHERE commission_pct IS NULLORDER BY last_name;

EMPLOYEES Table Sample Data

It returns employees with a commission_pct of 0, sorted by last_name.

It returns employees who do not have a commission_pct value, sorted by last_name.

It returns employees who have any commission_pct value, sorted by last_name.

It causes an error because NULL cannot be used in a WHERE clause.