Multiple Choice
Which query will output the table contents when the value of V_CODE is equal to 21344?
A) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <> 21344;
B) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <= 21344;
C) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344;
D) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE => 21344;
Correct Answer:

Verified
Correct Answer:
Verified
Q10: SQL allows the use of logical restrictions
Q20: An alias is especially useful when a
Q27: Using the command, SQL indexes can be
Q39: The SQL aggregate function that gives the
Q47: Any changes made to the contents of
Q50: SQL is considered difficult to learn; its
Q57: You cannot insert a row containing a
Q77: The ANSI prescribes a standard SQL-the current
Q80: Which query will output the table contents
Q87: The SQL character data format(s)is(are)_.<br>A) CHAR and