1Z0-071 practice question 30 of 35
Which two statements will convert the string Hello world to ello wozid?
Full set: 326 questionsSUBSTR('Hello world', 2) removes the first character, producing ‘ello world’. LOWER makes the string lowercase (already lowercase here). Option B applies LOWER to the SUBSTR; option D returns the same substring without calling LOWER—both yield exactly ‘ello world’. None of the other listed function combinations return the requested text.
A. SUBSTR length argument is 1, returning only ‘e’; result wrong.
C. TRIM removes only leading ‘H’; LOWER correct case but leaves ‘Hello world’ if H already absent; still includes capital W.
E. INITCAP capitalizes each word, giving ‘Hello World’, not the required lowercase ‘ello world’.
1. Oracle Database SQL Language Reference 19c – “Character Functions” → SUBSTR, syntax and examples.
2. Oracle Database SQL Language Reference 19c – “Character Functions” → LOWER; → INITCAP; → TRIM.
3. Stanford CS145 OpenCourse Notes – “String manipulation in Oracle SQL”, section on SUBSTR and case functions.
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
