Oracle
1Z0-047 · Question #147
View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SOL statement: SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alpha:]]') = 1; Which…
The correct answer is D. It would display all the street addresses where the first character is not a letter of the alphabet. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SOL statement:
SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alpha:]]') = 1; Which statement is true regarding the output of this SOL statement?
Exhibit
Options
- AIt would display all the street addresses that do not have a substring 'alpha'.
- BIt would display all the street addresses where the first character is a special character.
- CIt would display all the street addresses where the first character is a letter of the alphabet.
- DIt would display all the street addresses where the first character is not a letter of the alphabet.
How the community answered
(26 responses)- A4% (1)
- B8% (2)
- C4% (1)
- D85% (22)
Community Discussion
No community discussion yet for this question.
