Solved

Which WHERE Clause Can You Use with a SELECT Statement

Question 33

Multiple Choice

Which WHERE clause can you use with a SELECT statement to perform a case-insensitive search for rows containing the first name Marco?

A) WHERE FIRST_NAME = UPPER('MARCO')
B) WHERE FIRST_NAME = LOWER('MARCO')
C) WHERE LOWER(FIRST_NAME) = 'MARCO'
D) WHERE UPPER(FIRST_NAME) = 'MARCO'

Related Questions

Q25: Which command do you use to write

Q26: The DATE_ADD function has one argument.

Q27: MySQL procedures without error handling _.<br>A) display

Q28: How do you add a specific number

Q29: A trigger is executed _.<br>A) regularly at

Q30: What is the difference between a nonprocedural

Q31: A procedure that is executed automatically in

Q32: Applying the function ROUND(PRICE,0) to the price

Q34: How do you write a procedure to

Q35: What does the error code 1172 stand