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:

Crosstab Row

A row in a crosstab query that categorizes the data horizontally, facilitating comparison and analysis across different categories.

Query Design

The process or interface through which users build database queries using visual tools and elements to specify the data to retrieve or manipulate.

Long Text Fields

Database fields designed to store extensive amounts of text, such as descriptions or comments, allowing for detailed data entry.

Append Only

A setting in databases that allows data to be added but not deleted or modified, ensuring a historical data trail.