WebMusic’s Database Designer, Janet, Has Hired an Intern

question 24

Multiple Choice

WebMusic’s database designer, Janet, has hired an intern. She has requested that this intern create some SQL queries that would be useful to managers tracking the day-to-day operations of the store.
-Janet wants her intern to make some changes to the contents of records in the store's database.Which of the following commands would the intern use?

• A) PURGE
• B) INSERT
• C) JOIN
• D) UPDATE

---

Definitions:

Sales Increase

The rise in the amount of products or services sold by a company, usually compared to a previous period.

Contribution Margin

The amount by which sales revenue exceeds variable costs, representing the contribution towards covering fixed costs and generating profit.

Direct Material Costs

The expenditures for materials that are directly involved in the manufacturing process of a product.

Fixed Costs

Operating expenses that remain constant regardless of the business activity level, such as insurance or lease payments.