Answered

Westonci.ca is the best place to get answers to your questions, provided by a community of experienced and knowledgeable experts. Explore our Q&A platform to find reliable answers from a wide range of experts in different fields. Explore comprehensive solutions to your questions from knowledgeable professionals across various fields on our 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

We appreciate your time. Please come back anytime for the latest information and answers to your questions. Thank you for choosing our platform. We're dedicated to providing the best answers for all your questions. Visit us again. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.