Which of the Following SELECT Statements Will Select the ProdNum

question 58

Multiple Choice

Which of the following SELECT statements will select the ProdNum field from the tblProducts table,and then sort the records in descending order by the Price field?

• A)SELECT ProdNum FROM tblProductsSORT Price DESC
• B)SELECT ProdNum FROM tblProductsORDER BY Price DESC
• C)SELECT ProdNum FROM tblProductsWHERE Price DESC
• D)SELECT ProdNum FROM tblProductsORDER BY ProdNum DESC

---

Definitions:

Viscous Lava

Lava that has a thick, sticky consistency due to its high silica content, which causes it to flow slowly.

Scoria

A type of volcanic rock characterized by its vesicular texture and low density, formed from cooling lava.

Vesicular Basalt

A type of igneous rock characterized by a porous structure due to gas bubbles trapped in the lava during solidification.

Pillow Basalts

Pillow basalts are bulbous, spherical lava formations created when lava erupts underwater or flows into water, rapidly cooling and solidifying.