# 1z0-061 — Question 606

**Type:** multiple_choice
**Topics:** topic_1

## Question

View the Exhibit and evaluate the structure and data in the CUST_STATUS table.
//IMG//

You issue the following SQL statement:
//IMG//

Which statement is true regarding the execution of the above query?

## Correct Answer

_See scenario._

## Explanation

The NULLIF Function -
The NULLIF function tests two terms for equality. If they are equal the function returns a null, else it returns the first of the two terms tested.
The NULLIF function takes two mandatory parameters of any data type. The syntax is NULLIF(ifunequal, comparison_term), where the parameters ifunequal and comparison_term are compared. If they are identical, then NULL is returned. If they differ, the ifunequal parameter is returned.

**Reference:** examtopics_answer_description

---
Source: https://hiexam.net/q/oracle/1z0-061/606  
Practice (tracked): https://hiexam.net/study/1z0-061/practice