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:

OTC Market

Over-The-Counter Market, where securities are traded directly between parties without a central exchange, often used for stocks not listed on formal exchanges.

Double Taxation

A taxation principle referring to income taxes paid twice on the same source of earned income, commonly seen in corporate dividends.

Sole Proprietorships

A business owned and operated by a single individual, where the owner and the business are legally the same entity.

Bylaws

Regulations, rules, or laws adopted by an organization or community to govern its actions and the actions of its members.