Which of the Following Queries Uses the Correct SQL Syntax

question 76

Multiple Choice

Which of the following queries 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:

Preferential Payment

A financial transaction that gives prior payment to one creditor over others before a debtor's bankruptcy.

Insolvent Debtor

A debtor who cannot pay debts in a timely fashion.

Purchase Money Security Interest

A legal claim that allows creditors to repossess or claim goods as collateral if the buyer fails to meet the terms of the credit agreement, specifically concerning goods that were purchased with the loan.

Inventory

The total amount of goods and materials held by a business for the purpose of resale or production.