Oracle 1z0-071 Question Answer
Which two statements will convert the string Hello world to ello wozid?
SELECT LOWER (SUBSTR(‘Hello World, 2, 1)) FROM DUAL;
SELECT LOWER (SUBSTR(‘Hello World’, 2)) FROM DUAL;
SELECT LOWER(TRIM(‘H’ FROM ‘Hello World’)) FROM DUAL;
SELECT SUBSTR(‘Hello world’, 2) FROM DUAL;
SELECT INITCAP(TRIM(‘H’ FROM ‘Hello World’)) FROM DUAL;
To convert the string "Hello World" to "ello wozid":
Option B: SELECT LOWER(SUBSTR('Hello World', 2)) FROM DUAL;
This will remove the first character and convert the rest to lowercase, but it will not change the 'rld' to 'zid'.
Option D: SELECT SUBSTR('Hello world', 2) FROM DUAL;
This will remove the first character, but the rest of the string remains unchanged and not converted to lowercase.
Options A, C, and E are incorrect because:
Option A: SUBSTR is incorrect here because it is only getting one character instead of the entire string minus the first character.
Option C: While TRIM removes the 'H', LOWER converts all characters to lowercase, but it doesn't address the 'rld' to 'zid' change.
Option E: INITCAP and TRIM will not achieve the desired conversion of 'rld' to 'zid'.
TESTED 11 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved