Which of the Following Queries Will List All the Rows

question 10

Multiple Choice

Which of the following queries 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:

Congress

is the legislative branch of the United States federal government, composed of two houses: the Senate and the House of Representatives.

Peace Ship

Henry Ford's 1915 initiative to send a ship to Europe carrying American activists in an effort to negotiate an end to World War I; it was met with skepticism and did not achieve its goal.

Henry Ford

An American industrialist and founder of the Ford Motor Company who revolutionized factory production with his assembly line methods, significantly impacting the automobile industry.

Negotiated Settlement

A resolution reached through direct negotiations between parties, often used in legal disputes, conflicts, or diplomatic disagreements.