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

question 137

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.
-The intern needs to complete the following query so that it draws data from two different tables.Which command should she use to complete the query?
SELECT FROM Albums ____ Tracks ON Albums.Cat# = Tracks.Cat#

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

---

Definitions:

FICA Tax

A U.S. federal payroll tax that funds Social Security and Medicare, required to be paid by both employees and employers.

Price Elasticity

A measure of how much the quantity demanded of a good responds to a change in the price of that good.

Labor

The human effort, including both physical and mental, used in the production of goods and services.

Excise Tax

A tax charged on specific goods and services, such as gasoline and alcohol.