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.
View the Exhibit and examine the data in the LOCATIONS table.Evaluate the following SOL statement:SELECT street_address
-
- Site Admin
- Posts: 899566
- Joined: Mon Aug 02, 2021 8:13 am