The Following SELECT Statement: SELECT

question 62

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"

---

Definitions:

Return Requirement

The minimum expected rate of return necessary for an investment to be considered worthwhile by an investor, reflecting the risk level.

Annual Cash Flows

The total amount of money being transferred into and out of a business over the course of a year, indicative of its operational efficiency and profitability.

Ordinary Annuity

A series of equal payments made at the end of consecutive periods over a fixed length of time.

Annuity Due

A series of equal payments made at the beginning of consecutive periods over a fixed length of time.