Test your basic knowledge |

Django Queryset

Subject : it-skills

Instructions:

Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can study here.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.

1. When to run syncdb
distinct()
when you add new apps to INSTALLED_APPS
choices tuple
lt

2. If this option is True - the field is allowed to be blank. Default is False.
edit your settings file and change the INSTALLED_APPS setting to add the name of the module that contains your models.py.
related_name
range
blank

3. Lookup type that returns results in a given list.
delete()
Q(question__startswith='Who') | ~Q(pub_date__year=2005)
one-to-one relationship
in

4. This model method is used for updating a ManyToManyField.
istartswith
range
Q(question__startswith='Who') | ~Q(pub_date__year=2005)
add()

5. Returns an EmptyQuerySet -- a QuerySet that always evaluates to an empty list. This can be used in cases where you know that you should return an empty result set and your caller is expecting a QuerySet object (instead of returning an empty list - fo
all()
save()
get_absolute_url()
none()

6. Returns the most recent object in the table - by date - using the field_name provided as the date field.
latest(field_name=None)
month
Field lookups
lt

7. Lookup type that returns results less than a given value.
lt
Q(question__startswith='Who') | ~Q(pub_date__year=2005)
pickling
all()

8. This model type is useful if you only want to modify the Python-level behavior of a model - without changing the models fields in any way. This creates a stand-in for the original model. You can create - delete and update instances of this new model
Restrictions on field names
relationship spanning
related_name
Proxy model

9. Defined by a ManyToManyField. You use it just like any other Field type: by including it as a class attribute of your model.
pickling
Multi-table inheritance
many-to-many relationship
get_or_create(**kwargs)

10. Defined by django.db.models.ForeignKey. You use it just like any other Field type: by including it as a class attribute of your model.
many-to-one relationship
get(**kwargs)
Abstract base class
when you add new apps to INSTALLED_APPS

11. A Q object that encapsulates queries for entries with a question value that starts with 'What' in a case-insensitive fashion.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

12. This query finds all entries between a start date of start_date and an end date of end_date.
filter(**kwargs)
Entry.objects.filter(pub_date__range=(start_date - end_date))
choices
choices tuple

13. This query uses an F object to increment the pingback count for every entry in the blog.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

14. Fields are specified by these
class attributes
extra(select=None - where=None - params=None - tables=None - order_by=None - select_params=None)
Q()
==

15. This tells Django how to calculate the URL for an object. Django uses this in its admin interface - and any time it needs to figure out a URL for an object.
Q(question__istartswith='What')
lt
get_absolute_url()
reverse()

16. This style of inheritanc is useful when you're subclassing an existing model (perhaps something from another application entirely) and want each model to have its own database table. Here - each model in the hierarchy is a model all by itself.
choices
endswith
Multi-table inheritance
when you add new apps to INSTALLED_APPS

17. a QuerySet can be sliced - using Python's array-slicing syntax.
Custom model methods
update()
slicing
reverse name

18. Accomplish this by using the field name of related fields across models - separated by double underscores - until you get to the field you want. For example - to get all Entry objects with a Blog whose name is 'Beatles Blog': Entry.objects.filter(blo
relationship spanning
lt
reverse()
defer(*fields)

19. Returns a dictionary of aggregate values (averages - sums - etc) calculated over the QuerySet. Each argument to this method specifies a value that will be included in the dictionary that is returned.
Field lookups
get(**kwargs)
aggregate(args - *kwargs)
Meta class

20. If True - the table does not permit duplicate values for this field.
lte
dates(field - kind - order='ASC')
filter
unique

21. This model method saves a model instance to the database. This method has no return value.
save()
regex
Manager methods
Proxy model

22. Negation operator for Q objects.
default
endswith
reverse name
~

23. Disjunction operator for Q objects.
help_text
|
in_bulk(id_list)
iendswith

24. Lookup type that returns results with a case-insensitive end sequence.
default
iendswith
model
exclude(**kwargs)

25. Lookup type that returns results with a case-sensitive end sequence.
endswith
reverse name
primary_key
help_text

26. Performs an SQL update query for the specified fields - and returns the number of rows affected. This method is applied instantly and the only restriction on the QuerySet that is updated is that it can only update columns in the model's main table. F
update(**kwargs)
using(alias)
lt
reverse name

27. Used to get a QuerySet for a model. This is called 'objects' by default.
none()
Manager
__unicode__()
DoesNotExist

28. These are specified as keyword arguments to the QuerySet methods filter() - exclude() and get(). These take the form field__lookuptype=value .
Entry.objects.filter(id__in=[1 - 3 - 4])
endswith
update()
Field lookups

29. Manager method used to retrieve every object in a model.
Q()
all()
default
aggregate(args - *kwargs)

30. If True - this field is the primary key for the model.
create(**kwargs)
primary_key
year
filter chaining

31. An iterable (e.g. - a list or tuple) of 2-tuples to use as options for this field. If this is given - Django's admin will use a select box instead of the standard text field and will limit options to those given.
intermediate models
lt
relationship spanning
choices

32. Lookup type that returns results less than or equal to a given value.
lte
gt
in_bulk(id_list)
delete()

33. A QuerySet is iterable - and it executes its database query the first time you iterate over it.
iteration
Entry.objects.filter(pub_date__range=(start_date - end_date))
latest(field_name=None)
extra(select=None - where=None - params=None - tables=None - order_by=None - select_params=None)

34. This is a criterion that narrow down a QuerySet based on given parameters.
filter
==
year
reverse name

35. Lookup type for date/datetime fields that finds an exact month match. Takes an integer 1 (January) through 12
iteration
help_text
defer(*fields)
month

36. The database that will be used if this query is executed now
Model metadata
db
reverse()
evaluation

37. Adds to each object in the QuerySet with the provided list of aggregate values (averages - sums - etc) that have been computed over the objects that are related to the objects in the QuerySet. Each argument to this is content that will be added to ea
Q()
annotate(args - *kwargs)
clear() method
search

38. A convenience method for constructing an object and saving it all in one step.
isnull
istartswith
class attributes
create(**kwargs)

39. These add custom "row-level" functionality to your objects. These act on a particular model instance.
create(**kwargs)
~
primary_key
Custom model methods

40. This query deletes all Entry objects with a pub_date year of 2005.
select_related()
create(**kwargs)
get_or_create(**kwargs)
Entry.objects.filter(pub_date__year=2005).delete()

41. Lookup type that yields a case-insensitive match.
iexact
all()
only(*fields)
in

42. A Q object that asks for entries with a question value that start with 'Who' or do not have a publication date of 2005.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

43. Returns a QuerySet that will automatically "follow" foreign-key relationships - selecting that additional related-object data when it executes its query. This is a performance booster which results in (sometimes much) larger queries but means later u
select_related()
|
Q(question__startswith='Who') | ~Q(pub_date__year=2005)
reverse name

44. Lookup type that finds a case-insensitive regular expression match.
iregex
count()
lt
==

45. The value given in the absence of a specified value for the field. This can be a value or a callable object. If callable it will be called every time a new object is created.
iteration
contains
default
Entry.objects.filter(pub_date__range=(start_date - end_date))

46. This sets a field to a particular value for all the objects in a QuerySet. You can only set non-relation fields and ForeignKey fields using this method.
exact
choices tuple
only(*fields)
update()

47. Evaluates the QuerySet (by performing the query) and returns an iterator over the results. A QuerySet typically caches its results internally so that repeated evaluations do not result in additional queries; this method will instead read results dire
Multi-table inheritance
regex
iterator()
Model metadata

48. Performs an SQL delete query on all rows in the QuerySet. This method is applied instantly. You cannot call this method on a QuerySet that has had a slice taken or can otherwise no longer be filtered.
blank
istartswith
OneToOneField
delete()

49. Operator for comparing two model instances for equality. Behind the scenes - it compares the primary key values of two models.
==
exclude(**kwargs)
iendswith
month

50. what the field _______ determines: (1) The database column type (e.g. INTEGER - VARCHAR); (2) The widget to use in Django's admin interface - if you care to use it (e.g. <input type="text"> - <select>); (3) The minimal validation requirements - used
choices
class type
update(**kwargs)
Multi-table inheritance