Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q55: Joins are performed based on a predicate,which
Q56: The Where function allows you to limit
Q57: The SQL SELECT clause includes one or
Q58: When working with SQL,if a field includes
Q59: Many programs use a modified version of
Q61: The _ aggregate function limits the results
Q62: The following SELECT statement: SELECT *<br>FROM tblCustomers<br>WHERE
Q63: Everything you have learned how to do
Q64: The WHERE clause,which is required in a
Q65: When you edit a crosstab query in