What Result Set Will the Following Query Return

question 105

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:

Mastaba Tombs

Ancient Egyptian tombs of rectangular shape, featuring a flat roof and underground burial chambers.

False Doors

Architectural elements found mainly in Ancient Egyptian tombs and mortuary temples, symbolizing a doorway between the worlds of the living and the dead.

The Ka

An ancient Egyptian concept referring to the spiritual duplicate of the body that accompanies every human being throughout this life and into the next.

Hypostyle Hall

A large room with a roof supported by rows of columns, commonly found in ancient Egyptian temples but also used in other ancient architectures.