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:

Cardiac Muscle Cell

A specialized type of muscle cell found only in the heart, characterized by its ability to contract rhythmically.

Streptomycin

Streptomycin is an antibiotic utilized in treating various bacterial infections, notably tuberculosis and the plague, by inhibiting protein synthesis in bacteria.

Protein Synthesis

The process by which cells build proteins based on genetic instructions, involving transcription and translation stages.

Golgi Apparatus

A cell organelle involved in modifying, sorting, and packaging proteins and lipids for secretion or use within the cell.