The following SELECT statement: SELECT ProductName,ProductPrice
FROM tblInventory
WHERE ProductName Like "pr*";
Would list the ProductName and ProductPrice that ________.
A)begins with the letters "pr",such as pretzel,prime rib,and prosciutto
B)begins with the letters "pr",such as pretzel,prime rib,and prosciutto sorted in descending order
C)begins with the letters "pr",such as pretzel,prime rib,and prosciutto sorted in ascending order
D)contains the letters "pr",such as pretzel,prime rib,and prosciutto anywhere in the field

Question

Quizplus · Accepted Answer

The SELECT statement uses the Like operator with the wildcard character * to match all products that begin with the letters "pr". The WHERE clause filters the results based on this criteria, and only the ProductName and ProductPrice columns are selected. There is no mention of sorting in this statement.

The Following SELECT Statement: SELECT ProductName,ProductPrice