The Following SELECT Statement: SELECT ProductName,ProductPrice

question 60

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

---

Definitions:

Existing Position

A job role that is currently filled or established within an organization.

Human Resources

The department within an organization that deals with the hiring, administration, and training of personnel.

Screening Job Candidates

The process of evaluating potential employees to determine their suitability for a particular position.

Recruitment Advertising

Utilizing different media platforms to post job openings aimed at attracting a wide range of candidates; a rephrased definition for Employment Advertising.