Based on the Tables Below,which of the Following Commands in ANSI

question 14

Multiple Choice

Based on the tables below,which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

• A)SELECT * FROM SALESREP,CUSTOMER WHERE Balance > 400;
• B)SELECT DISTINCT RepName,CustName FROM SALESREP,CUSTOMER WHERE Balance > 400;
• C)SELECT * FROM SALESREP,CUSTOMER WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo AND Balance > 400;
• D)SELECT RepName,CustName FROM SALESREP,CUSTOMER WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo AND Balance > 400;
• E)SELECT RepName,CustName FROM SALESREP,CUSTOMER WHERE Balance > 400 GROUP BY SalesRepNo;

---

Definitions:

Matrix Structures

Organizational design combining two or more types of structures, typically combining functional and project-based divisions to enable more flexible and responsive operations.

Social Network Analysis

A methodological approach to study the relationships and structures within a network of individuals, organizations, or systems, using graph theory to visualize connections.

Organization Chart

A graphical representation depicting the structure of an organization, its departments, and employee hierarchy.

Formal Structure

A set of officially established rules and guidelines within an organization that dictates how it operates and how its members interact.