Question

Which of the following criterion expressions searches for PhoneNumber records where the phone number contains 10 characters and starts with a 9?
A) Like "9?????????"
B) Like "9*"
C) Contains "9?????????"
D) Contains #9*#

Answer 1

Answer:

A) Like "9?????????"

Explanation:

Required

10 characters and starts with 9

The options relate to queries in Microsoft Access; so, I will answer the question from the perspective of Microsoft Access.

First, the query will use the like statement because the query is to make comparison.

Next; for the search query to return exact 10 characters, the syntax is "??????????"

Lastly, for the search query to begin with 9, the first ? will be replaced with 9.

So, we have: "9?????????"

Hence, (a) is correct