🎴 Flashcard Mode
SQL and Oracle Database Administration
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which SELECT statement will the result 'ello world' from the string 'Hello World'?
AnswerClick to flip back
A
SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;
💡 Explanation:
The question asks for 'ello world' from 'Hello World'. The correct approach is to remove the first character 'H' and convert the result to lowercase. Option E does exactly this: TRIM('H' FROM 'Hello World') removes 'H' from the beginning, then LOWER() converts 'ello World' to 'ello world'. The other options either don't remove the first character correctly or have syntax errors like missing parentheses.