You need to display customers’ second names where the second name starts with "Mc" or "MC." Which query gives the required output?

Examine the data in the CUST_NAME column of the customers table.

You need to display customers’ second names where the second name starts with “Mc” or
“MC.” Which query gives the required output?

A.
Option A

B.
Option B

C.
Option C

D.
Option D