Multiple choice technology databases

Which SELECT statement will result "ello world" from the string "Hello World"?

  1. SELECT SUBSTR('Hello',) FROM dual;

  2. SELECT INITCAP(TRIM('Hello World',1,1)) FROM dual;

  3. SELECT LOWER(SUBSTR('Hello World',1,1)) FROM dual;

  4. SELECT LOWER(SUBSTR('Hello World',2,1)) FROM dual;

  5. SELECT LOWER(TRIM('H' FROM 'Hello World')) FROM dual;
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The TRIM function with 'H' FROM removes the first character H, then LOWER converts to lowercase. Option E correctly removes 'H' from the beginning and converts the result to lowercase, yielding 'ello world'. Other options either use incorrect functions or wrong parameters.

Keep practicing — related questions