OCP CBT Question 499

Please solve the following question.

Examine the following SQL statement:

sqlSELECT employee_id, salary, commission_pct, CASE WHEN commission_pct IS NOT NULL THEN salary * commission_pct ELSE salary * 0.05 END AS calculated_bonusFROM employees;Which statement is true regarding the execution of this SQL query?

Employees without a commission_pct will have a calculated_bonus of NULL.

Employees with a commission_pct of 0 will receive a bonus equal to their salary multiplied by 0.

The query will raise an error if any salary value is NULL.

The ELSE clause will only be executed for employees where commission_pct is explicitly NULL or has never been set.