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
Correct Answer:

Verified
Correct Answer:
Verified
Q2: When you don't know the specific value
Q16: An Insert query uses the _ statement
Q22: Case-Based Critical Thinking Questions Case 1 -
Q22: You save a query that contains the
Q28: Because it is possible for an error
Q40: You can use the _ associated with
Q45: The WHERE statement is the most commonly
Q46: The statement SELECT YearWon FROM tblMovies WHERE
Q49: What is a parameter query and how
Q51: The .xsd file is called the dataset's