Multiple Choice
Which of the following queries 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
Q26: The command is used to restore the
Q33: Explain the two SQL functions.
Q35: Which of the following queries will use
Q35: The query to join the P_DESCRIPT and
Q38: The data format for SQL character is
Q38: A table can be deleted from the
Q39: The SQL aggregate function that gives the
Q47: To delete an index, one must use
Q56: ANSI-standard SQL allows the use of special
Q68: With the exception of the database process,most