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

Verified
Correct Answer:
Verified
Q9: The syntax for creating an index is
Q12: The special operator is used to check
Q14: A database language enables the user to
Q34: What are the wildcard characters that are
Q36: A(n)is performed when data are retrieved from
Q44: Date procedures are often more software-specific than
Q48: Which of the following queries will use
Q53: The special operator used to check whether
Q60: The special operator used to check whether
Q69: In a 1:M relationship, a user must