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

Verified
Correct Answer:
Verified
Q6: In an INSERT command,you can indicate just
Q14: A database language enables the user to
Q14: If you add a new column to
Q16: To delete an index,use the _ command.
Q18: Entity integrity is enforced automatically when the
Q45: What is a subquery? When is it
Q54: UPDATE tablename *****<br>[WHERE conditionlist];<br>The command replaces the
Q55: Data type selection is usually dictated by
Q55: The SQL query to output the contents
Q102: The query used to list the P_CODE,