What Result Set Will the Following Query Return? Select Item_No

question 3

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:

Cost Variance

The difference between the expected cost of a project or production process and the actual cost incurred.

Labour Efficiency Variance

A measure used in cost accounting to evaluate the difference between the actual hours worked and the standard hours expected to produce a certain level of output.

Production Manager

The person responsible for overseeing the production process and ensuring that manufacturing runs smoothly and efficiently.

Management By Exception

A management system in which standards are set for various activities, with actual results compared to these standards. Significant deviations from standards are flagged as exceptions.