What Result Set Is Returned from the Following Query

question 67

Multiple Choice

What result set is returned from the following query?
Select customer_name,telephone
From customers
Where city in ('Boston','New York','Denver') ;

• A) The customer_name and telephone of all customers
• B) The customer_name and telephone of all customers living in either Boston, New York or Denver
• C) The customer_name and telephone of all customers living in Boston and New York and Denver
• D) The customer_name of all customers living in Boston, New York or Denver

---

Definitions:

Law Of Demand

An economic principle stating that as the price of a good increases, demand for that good decreases, and vice versa, all else being equal.

Prices Fall

A market condition where the cost of goods and services decreases over time.

Ceteris Paribus

A Latin phrase meaning "all other things being equal," used in economics to isolate the effect of one variable on another by holding all other relevant factors constant in an analytical context.

Law Of Demand

The economic principle that states there is an inverse relationship between the price of a good or service and the quantity demanded, ceteris paribus.