Study tips 1Z0-051

Which statements are true regarding single row functions?

What would be the outcome?

What would be the outcome?

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

Which two queries give the required output?

What is the outcome?

Which statements are true regarding data type conversion in expressions used in queries?

What is the outcome?

Which SQL statement would give the required result?

Which two queries give the correct result?