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

Verified
Correct Answer:
Verified
Q2: Which query will output the table contents
Q3: The SQL command that lets you permanently
Q4: With the exception of the _ process,most
Q6: In an INSERT command,you can indicate just
Q11: Which query will list all the rows
Q14: A database language enables the user to
Q54: UPDATE tablename *****<br>[WHERE conditionlist];<br>The command replaces the
Q55: String comparisons are made from left to
Q55: Data type selection is usually dictated by
Q102: The query used to list the P_CODE,