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:

Total Revenues

The overall amount of money received by a firm from sales of its products or services, before any costs are deducted.

Equilibrium Point

The condition in a market where the supply of goods matches demand, leading to a stable price and quantity for the good or service.

S And D Curves

In economics, the supply and demand curves which graphically represent the relationship between the quantity of goods that producers are willing to sell and consumers are willing to buy at different price levels.

Consumer Surplus

The contrast between the total price consumers are willing to pay for a good or service and the actual amount paid.