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}

Question

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}

Quizplus · Accepted Answer

A is the only query that correctly uses the greater than or equal to operator (>=) and the correct date format ('20-JAN-2010') to filter for inventory stock dates on or after January 20, 2010. B and D include incorrect syntax in their date formatting ('$' and '{ }'), and C uses the less than or equal to operator (<=), which would include dates before January 20, 2010.

Which Query Will List All the Rows in Which the Inventory