Answered

Westonci.ca is the ultimate Q&A platform, offering detailed and reliable answers from a knowledgeable community. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

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*#

Sagot :

MrRoyal

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

Thank you for choosing our service. We're dedicated to providing the best answers for all your questions. Visit us again. Thank you for your visit. We're committed to providing you with the best information available. Return anytime for more. Thank you for visiting Westonci.ca. Stay informed by coming back for more detailed answers.