# 1z0-144 — Question 606

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

## Question

View the Exhibit and examine the partial data in the PRODUCTS table.
PROD_ID is the primary key.
//IMG//

Examine the following code:
//IMG//

What is the outcome on execution of the above code?

## Correct Answer

_See scenario._

## Explanation

The right answer would be B. It gives an error because the DECODE function can be used only in a SQL statement.

**Reference:** examtopics_top_comment

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