Which Query Will Output the Table Contents When the Value

question 2

Multiple Choice

Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

• A) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
• FROM PRODUCT
• WHERE P_CODE <'1558-QW1';
• B) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
• FROM PRODUCT
• WHERE P_CODE = [1558-QW1]
• C) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
• FROM PRODUCT
• WHERE P_CODE = (1558-QW1)
• D) SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
• FROM PRODUCT
• WHERE P_CODE = {1558-QW1}

---

Definitions:

Bug-Infested Room

A room heavily infested with insects, which could refer to a detrimental environmental condition needing pest control measures.

Hotel Guest

An individual who rents a room or accommodation in a hotel for a temporary stay.

Distributive Fairness

The perceived fairness of the outcomes received, such as goods or services, in transactions or interactions between parties.

Overbooked Flights

Flights for which an airline has sold more tickets than there are seats available, often leading to passenger reaccommodation.