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

question 19

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}\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;

---

Definitions:

Behavior

The actions or reactions of an organism or system, usually in response to external stimuli.

Housing Preferences

The individual or collective choices and priorities made when selecting a place to live, influenced by factors such as location, size, price, and amenities.

Single Rooms

Rooms intended for occupancy by one person, often found in hotels, dormitories, or residential institutions.

Extraverts

Individuals characterized by their outgoing, sociable, and lively behaviors, often seeking stimulation from the external environment.