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

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}\text { SalesRepNo } & \text { RepName } & \text { HireDate } \\\hline 654 & \text { Tones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Tohnson } & 11 / 23 / 1998 \\\hline\end{array}$
CUSTOMER
$\begin{array}{l|l|l|l}\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\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;

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free