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

question 15

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:

Reflex

An automatic, involuntary response to a stimulus without the involvement of conscious thought.

Action Potential

A temporary reversal of an electrical charge across the membrane of a nerve cell that results in the transmission of an electrical impulse.

Central Nervous System

The part of the nervous system consisting of the brain and spinal cord, which acts as the processing center for nervous functions.

Motor-Control Information

Knowledge and processes involved in the planning, initiation, and regulation of physical movement.