Multiple Choice
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};
Correct Answer:

Verified
Correct Answer:
Verified
Q15: Which of the following queries is used
Q17: To list the contents of a table,you
Q18: Entity integrity is enforced automatically when the
Q19: The SQL aggregate function that gives the
Q22: An example of a command a user
Q23: The query to join the P_DESCRIPT and
Q24: A(n)is a query that is embedded inside
Q25: The command would be used to delete
Q38: The ANSI SQL standards are also accepted
Q53: The special operator used to check whether