Prev Question
Next Question

View the Exhibit and examine the data in the LOCATIONS table.

5a10496b1f813 - Which statement is true regarding the output of the following SQL statement?

Evaluate the following SQL statement:
SELECT street_address
FROM locations
WHERE
REGEXP_INSTR(street_address,'[^[:alpha:]]’) = 1;

Which statement is true regarding the output of this SQL statement?

A.
It would display all the street addresses that do not have a substring ‘alpha’.

B.
It would display all the street addresses where the first character is a special character.

C.
It would display all the street addresses where the first character is a letter of the alphabet.

D.
It would display all the street addresses where the first character is not a letter of the alphabet.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *