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:

Social

Relating to society or its organization, or pertaining to human interactions and relationships.

Environmental

Relating to the natural world and the impact of human activity on its condition, or the surroundings and conditions in which a person, animal, or plant lives or operates.

Task Performance

The effectiveness and efficiency with which an individual completes a specific job-related task or function.

Organizational Objectives

Organizational objectives are defined goals that a company aims to achieve, guiding its strategic and operational activities.