Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20,2016? A)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE = '20-JAN-2016'; 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,2016?
A)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2016';
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 uses the correct date format (day-month-year) and the comparison operator ">=" to select all rows where the P_INDATE column is on or after January 20, 2016. Option B uses incorrect syntax for the date format and includes a variable not defined in the query. Option C uses the wrong operator, "<=", and the wrong date. Option D uses incorrect syntax for the date and includes braces that are not necessary in this query.

Which of the Following Queries Will List All the Rows