Which Query Will List All the Rows in Which the Inventory

question 11

Multiple Choice

Which query will list all the rows in which the inventory stock dates occur on or after January 20,2010?

• A) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
• FROM PRODUCT
• WHERE P_INDATE >= '20-JAN-2010'
• B) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
• FROM PRODUCT
• WHERE P_INDATE >= $20-JAN-2010$
• C) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
• FROM PRODUCT
• WHERE P_INDATE <= '20-JAN-2010'
• D) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
• FROM PRODUCT
• WHERE P_INDATE >= {20-JAN-2010}

---

Definitions:

Market Decline

A decrease in the overall value of a market, evidenced by falling asset prices and often associated with economic downturns.

Inventory Valuation

A process used to determine the cost associated with an inventory at the end of a financial period, affecting the cost of goods sold and net income.

Average Cost Method

An inventory valuation method that calculates the cost of goods sold and ending inventory based on the weighted average cost of all items available for sale.

Average Cost

An inventory costing method where the cost of goods sold and ending inventory is determined by taking the weighted average of all units purchased.