Lab 6.3 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.

1)	A NULLIF function returns NULL if _____ expression1 equals expression2. _____ expression1 does not equal expression2.
2)	A NULLIF function is just like NVL function. _____ True _____ False
3)	You can specify literal NULL in the first expression of the NULLIF function. _____ True _____ False
4)	A COALESCE function returns _____ first null expression. _____ first non-null expression. _____ first expression only.
5)	You can never specify literal NULL as one of the expressions in the COALESCE function. _____ True _____ False

Answers appear in Appendix A, Section 6.3 .