The Following Code Would Include

question 55

Multiple Choice

The following code would include:
SELECT Customer_T.CustomerID,CustomerName, OrderID
FROM Customer_T RIGHT OUTER JOIN Order_T ON
Customer_T.CustomerID = Order_T.CustomerID;

• A) all rows of the Order_T Table regardless of matches with the Customer_T Table.
• B) all rows of the Customer_T Table regardless of matches with the Order_T Table.
• C) only rows that match both Customer_T and Order_T Tables.
• D) only rows that don't match both Customer_T and Order_T Tables.

---

Definitions:

Sales Returns

Transactions where customers return previously purchased merchandise to the seller, resulting in a deduction from gross sales to arrive at net sales.

Purchases Returns

Goods returned by a buyer to the seller, often due to defects or dissatisfaction, resulting in a refund or credit.

Purchase Discounts

Discounts a buyer receives for paying suppliers early, which are used to reduce the cost of purchased goods.

Net Purchases

Net purchases are the total amount of purchases minus returns, allowances, and discounts over a specified period, often used in analyzing inventory costs.