A developer wants to create a Java Persistence query that returns valid U.S.phone numbers (formatted as "123-456-7890" or "800-RUN-EJB3") from a collection of differently formatted international phone numbers. The developer needs only those numbers that begin with 303. Which WHERE clause is correct?

Question

Accepted Answer

E. WHERE addr. phoneLIKE 303-___-____'

Answer

A. WHERE addr. phone LIKE 303J

Answer

B. WHERE addr. phone LIKE 303%'

Answer

C. WHERE addr. phone LIKE303-_-_'

Answer

D. WHERE addr.phone LIKE 303-%-%'

Answer

F. WHERE addr. phone LIKE 303-%%%-%%%%'

A developer wants to create a Java Persistence query that returns valid U.S.phone numbers (formatted as "123-456-7890" or "800-RUN-EJB3") from a collection of differently formatted international…

Question

Options

How the community answered

Community Discussion