Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 231

Which two statements will convert the string Hello World to ello world? (Choose two.)

SELECT INITCAP(TRIM(‘H’ FROM ‘Hello World’)) FROM DUAL;

SELECT SUBSTR(‘Hello World’, 2) FROM DUAL;

SELECT LOWER(SUBSTR(‘Hello World’, 2, 1)) FROM DUAL;

SELECT LOWER(TRIM(‘H’ FROM ‘Hello World’)) FROM DUAL;

SELECT LOWER(SUBSTR(‘Hello World’, 2)) FROM DUAL;

Correct Answer: B, E

To convert 'Hello World' into 'ello world', we need to remove the initial 'H' and convert the string to lowercase. The statement using SUBSTR('Hello World', 2) will remove the first character, resulting in 'ello World'. Then, using LOWER on this result will convert 'ello World' to 'ello world'. Therefore, these two statements: SUBSTR('Hello World', 2) and LOWER(SUBSTR('Hello World', 2)) will achieve the desired result.

Discussion

billysunday1Options: DE

D and E is correct

onandiOptions: DE

D, E are correct

JUMP56Options: DE

DE are correct