Bird
0
0

Which of the following is the correct way to represent a filter for price less than $100 in a query parameter?

easy📝 Conceptual Q12 of 15
LLD - Design — Hotel Booking System
Which of the following is the correct way to represent a filter for price less than $100 in a query parameter?
Aprice>100
Bprice<100
Cprice=100
Dprice!=100
Step-by-Step Solution
Solution:
  1. Step 1: Understand comparison operators in queries

    The symbol '<' means less than, so 'price<100' filters prices below 100.
  2. Step 2: Eliminate incorrect operators

    '>' means greater than, '=' means equal, '!=' means not equal, so they don't match 'less than 100'.
  3. Final Answer:

    price<100 -> Option B
  4. Quick Check:

    Less than operator = A [OK]
Quick Trick: Use '<' for less than in filters [OK]
Common Mistakes:
  • Using '>' instead of '<' for less than
  • Confusing '=' with less than
  • Using '!=' which means not equal

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More LLD Quizzes