Which statement is true regarding the output of the following SQL statement?

View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SQL statement:
SELECT street_address
FROM locations
WHERE
REGEXP_INSTR(street_address,'[^[:alpha:]]’) = 1;
Which statement is true regarding the output of this SQL statement?

View the Exhibit and examine the data in the LOCATIONS table.

Evaluate the following SQL statement:
SELECT street_address
FROM locations
WHERE
REGEXP_INSTR(street_address,'[^[:alpha:]]’) = 1;

Which statement is true regarding the output of this SQL 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 0

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