Based on the Code Shown, Which Query Lists the Number

question 23

Multiple Choice

Based on the code shown, which query lists the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file, or both???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer ;
• B) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ;
• C) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' WHERE Customer.CustomerNum=Orders.CustomerNum ;
• D) SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders ;

---

Definitions:

Perfect Reliability

Perfect reliability refers to a hypothetical situation where a measurement is completely free from error, achieving a reliability coefficient of 1.

Coefficient

A numerical or constant quantity placed before and multiplying the variable in an algebraic expression, or a measure used to describe a statistical relationship.

Occurrence

An instance or event that takes place or happens, often used to refer to the frequency of events in a given context.

Predictive Validity

The extent to which a score or measure can predict future performance or behavior.