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};

Question

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};

Quizplus · Accepted Answer

Option A correctly uses the greater than or equal to operator (>=) and the date value is in the correct format ('20-JAN-2010'). Option B uses dollar signs around the date value which is not correct syntax. Option C uses the less than or equal to operator (<=) which would result in listing all the rows with dates prior to or on January 20, 2010. Option D uses curly braces around the date value which is not correct syntax.

Which of the Following Queries Will List All the Rows