Q objects for complex queries in Django - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What does this Django query return?

Given the Django model Book with fields title and published_year, what does this query return?

Book.objects.filter(Q(title__icontains='python') | Q(published_year__gte=2020))

A Books with titles containing 'python' and published in or after 2020

B Books published before 2020 or titles not containing 'python'

C Books published before 2020 and titles containing 'python'

D Books with titles containing 'python' or published in or after 2020

💡 Hint

Remember that the | operator means OR in Q objects.

The query uses Q objects combined with | which means OR. So it returns books where the title contains 'python' OR the published year is 2020 or later.

📝 Syntax

intermediate

Identify the syntax error in this Q object query

Which option shows the syntax error in combining Q objects to filter Author model by name and age?

Django

Author.objects.filter(Q(name='Alice') & Q(age__gt=30))

A Q(name='Alice') and Q(age__gt=30)

B )03=tg__ega(Q & )'ecilA'=eman(Q

C Q(name='Alice') & Q(age__gt=30)

D Q(name='Alice') | Q(age__gt=30)

💡 Hint

Check the operator used between Q objects.

Using Python's 'and' between Q objects causes a syntax error because Q objects require bitwise operators (& or |) for combining.

❓ state_output

advanced

What is the count of results from this query?

Assuming the Product model has 10 items with category='electronics' and 5 items with price__lt=100, what is the count of Product.objects.filter(Q(category='electronics') & Q(price__lt=100))?

A 5

B Cannot determine without more info

C 15

D 10

💡 Hint

Think about how many products satisfy both conditions together.

The query filters products that are both electronics and priced below 100. Without knowing the overlap count, we cannot determine the exact number.

🔧 Debug

advanced

Why does this Q object query raise an error?

Consider this query:
Entry.objects.filter(Q(pub_date__year=2023) | 'title__icontains=django')
Why does it raise an error?

A Because the second part is a string, not a Q object

B Because Q objects cannot use | operator

C Because pub_date__year is invalid lookup

D Because filter() cannot accept Q objects

💡 Hint

Check the types combined with the | operator.

The | operator expects both sides to be Q objects. A string on the right side causes a TypeError.

🧠 Conceptual

expert

How to exclude objects matching multiple conditions using Q objects?

Which query excludes Customer objects whose status is 'inactive' or last_login is before 2022-01-01?

A Customer.objects.exclude(Q(status='inactive') & Q(last_login__lt='2022-01-01'))

B Customer.objects.filter(~Q(status='inactive') & ~Q(last_login__lt='2022-01-01'))

C Customer.objects.exclude(Q(status='inactive') | Q(last_login__lt='2022-01-01'))

D Customer.objects.filter(Q(status!='inactive') | Q(last_login__gte='2022-01-01'))

💡 Hint

Use exclude() with OR inside Q to remove any matching either condition.

exclude(Q(... | ...)) removes objects matching either condition. Option C filters for objects matching neither condition, which is equivalent but more complex. Option C excludes only those matching both conditions. Option C uses invalid syntax.