Register Login

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

Updated May 18, 2018

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

A. INSTR returns the numeric position of a named character

B. NVL 2 returns the first non-null expression in theexpression list.

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

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

E. TRIM trims the leading or trailing characters (or both) from a character string.

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

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

Answer : ADEG


Comments

  • 05 Jun 2010 4:53 pm Guest
    correct

×