What Will Be Returned When the Following SQL Statement Is

question 12

Multiple Choice

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

• A) A listing of all drivers, sorted by driver number
• B) A listing of each driver as well as the number of deliveries that he or she has made
• C) A count of all of the deliveries made by all drivers
• D) None of the above

---

Definitions:

Functional Group

A specific grouping of atoms within molecules that is responsible for the characteristic chemical reactions of those molecules.

Organic Explosives

Explosive materials composed of organic chemicals that produce a detonation or rapid expansion of gases to generate destructive effects.

Combustion

A chemical reaction that occurs when a substance reacts with oxygen to give off heat and light, often producing flame.

Explosives

A rephrased definition: Chemical compounds or mixtures that release a large amount of energy in a very short time through blasts or combustion.