Based on the Tables Below,which of the Following SQL Commands

question 81

Multiple Choice

Based on the tables below,which of the following SQL commands would create an SQL view named CustomerSalesRep that could be used to display CustNo,CustName,RepName?
GENERAL SALES DATABASE:
SALESREP
$$\begin{array} { l | l | l | } \hline \text { SalesRepNo } & \text { RepName } & \text { HireDate } \\\hline 654 & \text { Jones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Johnson } & 11 / 23 / 1998 \\\hline\end{array}$$
CUSTOMER
$$\begin{array} { | l | l | l | l | } \hline \text { CustNo } & \text { CustName } & \text { Balance } & \text { SalesRepNo } \\\hline 9870 & \text { Winston } & 500 & 345 \\\hline 8590 & \text { Gonzales } & 350 & 434 \\\hline 7840 & \text { Harris } & 800 & 654 \\\hline 4870 & \text { Miles } & 100 & 345 \\\hline\end{array}$$

• A) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER;
• B) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER
• WHERE CustNo=*;
• C) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER
• WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
• D) CREATE VIEW CustomerSalesRep AS SELECT CustNo, CustName, RepName
• FROM SALESREP, CUSTOMER
• WHERE CustNo=*;
• E) CREATE VIEW CustomerSalesRep AS SELECT CustNo, CustName, RepName
• FROM SALESREP, CUSTOMER
• WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;

---

Definitions:

Antitrust Law

Legislation aimed at preventing anti-competitive practices, monopolies, and other actions that restrict or distort market competition.

Economic Efficiency

A situation in which every resource is optimally allocated to serve each individual or entity in the best way while minimizing waste and inefficiency.

Chicago School

An economic school of thought advocating for minimal government intervention in markets, emphasizing the importance of free-market principles.

Trust

A fiduciary relationship where one party, known as the trustee, holds property or assets for the benefit of another party, called the beneficiary.