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'

---

Definitions:

John Locke

a 17th-century English philosopher and political theorist known for his contributions to liberalism, social contract theory, and the concept of personal identity.

Thomas Hobbes

A 17th-century English philosopher known for his work on political philosophy, particularly his book "Leviathan," positing the foundation of societies and governments.

Natural State

A condition or situation perceived as inherent and untouched by human influence, often referring to environments or human behavior.

Thomas Hobbes

A 17th-century English philosopher known for his work on political philosophy, especially as articulated in his book "Leviathan," where he discusses the structure of society and legitimate government.