Multiple choice technology databases

which of the following comes under General Functions category in Single Row Functions

  1. COALESCE()

  2. NVL()

  3. NVL2()

  4. CASE
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

General Functions in Oracle handle NULL values: NVL(expr1, expr2) returns expr2 if expr1 is NULL. COALESCE(expr1, expr2, ...) returns the first non-NULL expression. NVL2(expr1, expr2, expr3) returns expr2 if expr1 is not NULL, else expr3. CASE provides conditional logic. All four are general functions.

AI explanation

Marked correct (all four): COALESCE(), NVL(), NVL2(), CASE. In Oracle SQL's Single-Row Functions taxonomy, the 'General Functions' group covers functions/expressions that operate on NULLs and conditional logic rather than pure string/number/date manipulation — COALESCE, NVL, and NVL2 are textbook members of this group, and CASE (a conditional expression) is commonly taught alongside them in the same category by many Oracle courses/certifications, even though some references classify CASE separately under 'conditional expressions.' Given the training-material framing of this question, treating all four as correct (MC-2 with all options true) is defensible.

Keep practicing — related questions