Based on the Tables Below, Which Command Creates a New

question 22

Multiple Choice

Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum) ?SalesPerson (SalesPersonNum, LastName, FirstName)

• A) PROJECT Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales
• B) UNION Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales
• C) SELECT Customer SalesPerson JOIN Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales
• D) JOIN Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales

---

Definitions:

Highly Elastic

Refers to a strong responsiveness of the quantity demanded or supplied of a good to a change in its price.

Statutorily Granted

Pertains to rights or powers given or enforced by a legislative body or statute.

Government Subsidy

Financial assistance provided by the government to individuals, organizations, or industries to support their operation or reduce the price of their products.

Market Price

The current price at which an asset or service can be bought or sold in the market.