What Result Set Will the Following Query Return

question 2

Multiple Choice

What result set will the following query return?
SELECT Item_No, description
FROM item
WHERE weight > 100 and weight < 200;

• A) The Item_No and description for all items weighing less than 100
• B) The Item_No for all items weighing between 101 and 199
• C) The Item_No and description for all items weighing between 101 and 199
• D) The Item_No for all items weighing more than 200

---

Definitions:

Contract

A legal agreement between two or more parties that creates mutual obligations enforceable by law.

Liable

Legally responsible or obligated to someone or something, often used in the context of legal judgments or debts.

Disclosed Principal

A principal whose identity is known to a third party. The third party is aware that the agent is making an agreement on behalf of the principal.

Third Party

An individual or group besides the two primarily involved in a transaction or legal situation, often providing additional services or involvement.