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

Question

Options

• AINSTR returns the numeric position of a named character.
• BNVL2 returns the first non-null expression in the expression list.
• CTRUNCATE rounds the column, expression, or value to n decimal places.
• DDECODE translates an expression after comparing it to each search value.
• ETRIM trims the heading of trailing characters (or both) from a character string.
• FNVL compares two expressions and returns null if they are equal, or the first expression of they
• GNULLIF compares twp expressions and returns null if they are equal, or the first expression if they

• A
  77% (33)
• B
  14% (6)
• C
  2% (1)
• F
  7% (3)

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. Incorrect Answers B: This statement is not correct. The following is the Syntax for NVL2 function: NVL2(expr1, expr2, expr3). If expr1 is not null, NVL2 returns expr2. If expr1 is null, NVL2 returns expr3. C: Command TRUNCATE is used to remove all row data from the table, while leaving the definition of the table intact, including the definition of constraints and any associated database objects as indexes, constraints, and triggers on the table. F: NVL returns second parameter value if first one is NULL.

No community discussion yet for this question.