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 4

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


Joao Bento

Joao Bento

All answers are correct, making this an exercise in futility.