Millionaire Mode

Oracle Database: SQL, RMAN, and IDMS Fundamentals

Question 1 of 20

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.

Prize Money

15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000