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:

Sea Stars

Sea stars, also known as starfish, are marine invertebrates belonging to the class Asteroidea, known for their radial symmetry and a body plan consisting of a central disc from which arms (or rays) extend.

Intertidal Zone

The area of the shoreline that is exposed to the air at low tide and submerged under water at high tide, home to diverse organisms.

Mussels

Aquatic mollusks with a bivalve shell, widely consumed as seafood, and known for their role in aquatic ecosystems as filter feeders.

Keystone

An essential element or species that plays a critical role in maintaining the structure of an ecological community, affecting many other organisms within the community.