Which Query Uses the Correct SQL Syntax to List the Table

question 57

Multiple Choice

Which query uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

• A) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
• FROM PRODUCT
• WHERE V_CODE = 21344
• OR V_CODE <= 24288
• B) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
• FROM PRODUCT
• WHERE V_CODE = 21344
• OR V_CODE => 24288
• C) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
• FROM PRODUCT
• WHERE V_CODE = 21344
• OR V_CODE > 24288
• D) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
• FROM PRODUCT
• WHERE V_CODE = 21344
• OR V_CODE = 24288

---

Definitions:

Production Budget

A financial plan that estimates the number of units to be produced to meet sales goals within a given period.

Raw Materials

Fundamental components or substances used at the beginning of the production process to manufacture goods.

Raw Material Costs

The total expense incurred for materials that are used in the production of goods or services.

Beginning Inventory

The value of the total goods available for sale at the start of an accounting period.