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

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?

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?

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.



Leave a Reply 1

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