Multiple Choice
The following SELECT statement: SELECT *
FROM tblCustomers
WHERE LastName Like "smith";
Would list ________.
A) all customers first and last names from tblCustomers with a last name that begins with "smith"
B) all fields from tblCustomers with a last name that begins with "smith"
C) all fields from tblCustomers where the customers' last name is "smith"
D) all fields from tblCustomers where the customers' last name contains "smith"
Correct Answer:

Verified
Correct Answer:
Verified
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
Q60: The following SELECT statement: SELECT ProductName,ProductPrice<br>FROM tblInventory<br>WHERE
Q61: The _ aggregate function limits the results
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
Q66: The _ can compare the portion of
Q67: Revenue is income that a company receives