Pergunta de entrevista da empresa W Energy Software

What are the NVL and the NVL2 functions in SQL? How do they differ? What is the difference between the WHERE and HAVING clauses?