View the Exhibit and examine the data in the LOCATIONS table.Evaluate the following SOL statement:SELECT street_address
Posted: Wed Jun 07, 2023 6:11 am
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.
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.