OCP CBT Question 500

Please solve the following question.

You need to display the `commission_pct` for all employees. If an employee does not have a commission (i.e., `commission_pct` is NULL), you want to display 0 instead of NULL. Which function should you use?

EMPLOYEES Table StructuresqlDESC EMPLOYEES;Name Null? Type----------------- -------- -------------COMMISSION_PCT NUMBER(2,2)...