Which SELECT statement will the result ello world' from the string Hello World'?

The correct answer is E. SELECT LOWER(TRIM (`H' FROM `Hello World')) FROM dual. This statement will return correct result because function TRIM() will trim letter H' in the Hello World' and function LOWER() will return data in string in lowercase.. Incorrect Answers A: This statement will return sub-string starting at the character in position number Y to…

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

Which SELECT statement will the result ello world' from the string Hello World'?

Options

ASELECT SUBSTR( `Hello World',1) FROM dual;
BSELECT INITCAP(TRIM (`Hello World', 1,1)) FROM dual;
CSELECT LOWER(SUBSTR(`Hello World', 1, 1) FROM dual;
DSELECT LOWER(SUBSTR(`Hello World', 2, 1) FROM dual;
ESELECT LOWER(TRIM (H' FROM Hello World')) FROM dual;

How the community answered

(27 responses)

A
15% (4)
B
4% (1)
C
4% (1)
D
7% (2)
E
70% (19)

Explanation

This statement will return correct result because function TRIM() will trim letter H' in the Hello World' and function LOWER() will return data in string in lowercase.. Incorrect Answers A: This statement will return sub-string starting at the character in position number Y to the end. B: There is incorrect syntax in the TRIM() function. C: There is incorrect syntax in that statement because of absence right bracket. D: There is incorrect syntax in that statement because of absence right bracket.

Topics

#LOWER#TRIM#SUBSTR#string functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice