View the Exhibit and examine the data in the LOCATIONS table.Evaluate the following SOL statement:SELECT street_address

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

View the Exhibit and examine the data in the LOCATIONS table.Evaluate the following SOL statement:SELECT street_address

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply