📚 Practice Mode

SQL and Oracle Database Administration

Learn at your own pace with hints and detailed explanations

1 / 20
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;