SQL and Oracle Database Administration

Casual Mode - Take your time!

1 / 20
Correct
0
Incorrect
0
Score
0%
Multiple Choice

Which SELECT statement will the 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;
Change Mode