OCP CBT Question 501

Please solve the following question.

Examine the following SQL statement:

sqlSELECT employee_id, NVL2(commission_pct, 'Commissioned', 'Not Commissioned') AS commission_statusFROM employees;What is the expected output for an employee with a commission_pct of 0.15 and an employee with a NULL commission_pct?

0.15: 'Commissioned', NULL: 'Not Commissioned'

0.15: 'Commissioned', NULL: 'Commissioned'

0.15: 'Not Commissioned', NULL: 'Commissioned'

0.15: 'Not Commissioned', NULL: 'Not Commissioned'