Why ORM maps Python to database in Django - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why use ORM in Django?

What is the main reason Django's ORM maps Python classes to database tables?

A To make the database run faster by converting Python code directly into machine code

B To allow developers to work with database data using Python objects instead of SQL queries

C To replace the need for a database by storing all data in Python memory

D To automatically generate HTML pages from Python classes without templates

💡 Hint

Think about how ORM helps developers avoid writing raw SQL.

Django's ORM lets developers use Python classes and objects to interact with the database. This means you write Python code instead of SQL queries, making database work easier and less error-prone.

❓ component_behavior

intermediate

What happens when you save a Django model instance?

Given a Django model instance, what does calling the .save() method do in terms of ORM behavior?

Django

class Book(models.Model):
    title = models.CharField(max_length=100)

book = Book(title='Learn Django')
book.save()

A It creates or updates a row in the database table corresponding to the Book model

B It only updates the Python object in memory without affecting the database

C It deletes the corresponding row from the database

D It generates an HTML page showing the book details

💡 Hint

Think about how ORM syncs Python objects with the database.

Calling .save() on a Django model instance tells the ORM to write the data to the database. If the object is new, it inserts a new row; if it exists, it updates the row.

📝 Syntax

advanced

Identify the correct Django ORM query syntax

Which option correctly retrieves all Book objects with title 'Django Basics' using Django ORM?

A Book.objects.get_all(title='Django Basics')

B Book.filter(title='Django Basics')

C Book.objects.find(title='Django Basics')

D Book.objects.filter(title='Django Basics')

💡 Hint

Remember the Django ORM uses 'objects' manager and 'filter' method for queries.

The correct way to query multiple objects matching a condition is using Book.objects.filter(). Other options are invalid methods or missing the manager.

🔧 Debug

advanced

Why does this Django ORM query raise an error?

What error will this code raise and why? class Author(models.Model): name = models.CharField(max_length=50) # Query: Author.objects.get(name='Unknown')

A TypeError because name field is not a string

B MultipleObjectsReturned error because more than one Author has name 'Unknown'

C DoesNotExist error because no Author with name 'Unknown' exists

D SyntaxError because get() requires a list of names

💡 Hint

What happens if get() finds no matching record?

The get() method expects exactly one matching record. If none exist, Django raises a DoesNotExist error.

❓ state_output

expert

What is the output of this Django ORM code snippet?

Consider this code: class Product(models.Model): name = models.CharField(max_length=50) price = models.DecimalField(max_digits=5, decimal_places=2) Product.objects.create(name='Pen', price=1.50) Product.objects.create(name='Notebook', price=3.00) cheap_products = Product.objects.filter(price__lt=2.00) print(list(cheap_products.values_list('name', flat=True))) What will be printed?

A ['Pen']

B ['Pen', 'Notebook']

C []

D ['Notebook']

💡 Hint

Look at the filter condition price__lt=2.00 and which products match.

The filter price__lt=2.00 selects products with price less than 2.00. Only 'Pen' has price 1.50, so the output is ['Pen'].