What Will Be Returned When the Following SQL Statement Is

question 62

Multiple Choice

What will be returned when the following SQL statement is executed? Select driver_no, count(*) as num_deliveries
From deliveries
Where state = 'MA'
Group by driver_no;

• A) A listing of all drivers who made deliveries to state = 'MA', sorted by driver number
• B) A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state
• C) A count of all of the deliveries made to state = 'MA' by all drivers
• D) An error message will be generated

---

Definitions:

Binomial Experiment

An experiment or trial that can be reduced to two outcomes, success or failure, and is repeated a fixed number of times.

Continuous Random Variables

Variables capable of assuming any value within a specified range, with the potential for infinite variations.

Binomial Distribution

A probability distribution that summarizes the likelihood that a variable will take one of two independent values under a given set of parameters or conditions.

Independent Trials

Independent Trials are experiments or processes in which the outcome of any given trial does not affect the outcome of any other trial.