A MySQL Database Includes a CUSTOMER Table, Which Stores Each

question 32

Multiple Choice

A MySQL database includes a CUSTOMER table, which stores each customer's current balance in U.S. dollars and cents, among other information. The correct data type for the BALANCE column in the CUSTOMER table is _____.

• A) CHAR
• B) INT
• C) SMALLINT
• D) DECIMAL

---

Definitions:

Standard Costs

Predicted costs associated with manufacturing or providing a service, used for budgetary control and performance analysis.

Cash Account

An account that tracks the flow of cash transactions, including all receipts and payments of cash.

Standard Cost Variances

Differences between the planned (standard) costs and the actual costs incurred.

Cost of Goods Sold

The cost of goods sold (COGS) is the direct cost attributable to the production of goods sold by a company, including the cost of materials and labor.