Which query would you enter to query for all such accounts?

You are cleaning up account data in the system. You know that your company maintains several different
Marriott accounts such as Marriott, Marriott Europe, and Marriott Asia. All such accounts should start with
the word Marriott. Unfortunately, users have used these different spellings for the accounts: Marriott,
Marriot, Mariott, and Mariot. Which query would you enter to query for all such accounts?

You are cleaning up account data in the system. You know that your company maintains several different
Marriott accounts such as Marriott, Marriott Europe, and Marriott Asia. All such accounts should start with
the word Marriott. Unfortunately, users have used these different spellings for the accounts: Marriott,
Marriot, Mariott, and Mariot. Which query would you enter to query for all such accounts?

A.
Mar?iot?

B.
Mar?iot?*

C.
Mar*iot*

D.
IS LIKE (Mar?iot?)

E.
IS LIKE (Mar*iot*)



Leave a Reply 0

Your email address will not be published. Required fields are marked *