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 ‘alpha1.

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 0

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