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; D) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE = 10;

Question

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;

Quizplus · Accepted Answer

The query B selects the columns P_DESCRIPT, P_INDATE, P_PRICE, and V_CODE from the table PRODUCT where the value of P_PRICE is less than or equal to 10. The operator <= means "less than or equal to." Option A selects all rows where the value of P_PRICE is not 10, while option C uses the incorrect operator =>, which should be >=. Option D selects only rows where the value of P_PRICE is equal to 10.

Which of the Following Queries Will Output the Table Contents