📚 Practice Mode

Oracle Database: SQL, RMAN, and IDMS Fundamentals

Learn at your own pace with hints and detailed explanations

1 / 20
Multiple Answers

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

  1. INSTR returns the numeric position of a named character.
  2. NVL2 returns the first non-null expression in the expression list.
  3. TRUNCATE rounds the column, expression, or value to n decimal places.
  4. DECODE translates an expression after comparing it to each search value.
  5. TRIM trims the heading or trailing characters (or both) from a character string.
  6. NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
Change Mode