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:

Overpromotion Syndrome

The situation that occurs when an employee is promoted beyond their level of competence, often leading to stress and performance issues.

Employee Morale

A rephrased version of Morale Building that focuses on the confidence, enthusiasm, and satisfaction levels of individuals within an organization, significantly impacting productivity and retention.

Laurence J. Peter

A Canadian educator and "hierarchiologist" best known for formulating the Peter Principle, which posits that people in a hierarchy tend to rise to their level of incompetence.

Top Managers

Individuals who hold the highest level of managerial roles in an organization, responsible for setting strategic goals and making overarching decisions.