Which four statements correctly describe functions that are available in SQL?

Which four statements correctly describe functions that are available in SQL? (Choose four.)

A.
TRUNCATE rounds the column, expression, or value to n decimal places.

B.
TRIM trims the heading or trailing characters (or both) from a character string.

C.
DECODE translates an expression after comparing it to each search value.

D.
INSTR returns the numeric position of a named character.

E.
NVL compares two expressions and returns null if they are equal, or the first expression if they
are not equal.

F.
NULLIF compares two expressions and returns null if they are equal, or the first expression if
they are not equal.

G.
NVL2 returns the first non-null expression in the expression list.

Explanation:

INSTR returns the numeric position of a named character. DECODE translates an expression after
comparing it to each search value. TRIM trims the heading of trailing characters (or both) from a
character string. NULLIF compares twp expressions and returns null if they are equal, or the first

expression if they are not equal.