Case-Based Critical Thinking Questions Case 1 - LuvUrPet

question 25

Multiple Choice

Case-Based Critical Thinking Questions Case 1 - LuvUrPet
The database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers.
An application using the dataset should allow a user to type in a price to use to query the dataset. Which of the following clauses would allow a user to select the records for collars with a price of 15 or more?

• A) WHERE Price >= 15
• B) WHERE Price Like 15
• C) WHERE Price >= ?
• D) WHERE Price

---

Definitions:

Engineered

The process of designing, constructing, and testing structures, materials, and systems based on scientific principles.

Operating Leverage

An indicator of the extent to which increases in revenue lead to increases in operating profit, showing the level of fixed expenses within the financial framework of a business.

Fixed Costs

Expenses that do not change with the level of production or sales over a short period, such as rent, salaries, and insurance.

Forecasting Risk

The potential for future revenues or earnings to deviate from projected amounts due to variables that affect demand, supply, and pricing.