Microsoft
MB6-890 · Question #8
MB6-890 Question #8: Real Exam Question with Answer & Explanation
Sign in or unlock MB6-890 to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Question
Your solution stores customers in a table named Gust Table. CustTable contains a field named AccountNum, which is used to store the unique account number for a customer. Data in the AccountNum field is 4 characters in length. You need to retrieve only the records in CustTable where the second character of the Account Number is the letter "H". How should you write the select statement?
Options
- Aselect * from CustTable where CustTable.AccountNum like "*H"
- Bselect * from CustTable where CustTable.AccountNum like "*H?"
- Cselect * from CustTable where CustTable.AccountNum like "H*"
- Dselect * from CustTable where CustTable.AccountNum like "?H*"
Unlock MB6-890 to see the answer
You've previewed enough free MB6-890 questions. Unlock MB6-890 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.