Developing Applications with SQL, Databases, and Django Quiz Answers - Coursera!

Developing Applications with SQL, Databases, and Django complete course is currently being offered by IBM through Coursera platform and is being taught by Yan Luo and Rav Ahuja. This course is part of the IBM Full Stack Software Developer Professional Certificate

Learning Outcomes

- Explain what a database is and create an entity relationship data model for a relational database.

- Compose SQL queries to insert, select, update, delete data in a database.

- Use Django ORM to build object-oriented databases.

- Integrate Bootstrap into your Django template and build interactive web pages.

Skills You Will Gain

• Django (Web Framework)
• Database (DBMS)
• Cloud Applications
• SQL

Also Check: How to Apply for Coursera Financial Aid

Course Link: https://www.coursera.org/learn/developing-applications-with-sql-databases-and-django

Developing Applications with SQL, Databases, and Django Week 1 to Week 4 Quiz Answers - Coursera!

Graded Quiz: Introduction to Databases

Question 1) Which of the following statements are correct about databases?

All of the above

Question 2) A database stores data in tabular form only. True or False?

False

 

Question 3) In a library entity-relationship data model, a book is an example of _____ and the book’s title, edition, and publication date are examples of _______.

an entity, attributes

Question 4) Which of the following statements about a database is/are correct?

A database is a logically coherent collection of data with some inherent meaning

Question 5) The primary key of a relational table uniquely identifies each row in a table. True or False?

True

Graded Quiz: Basic SQL Statements

Question 1) What is the correct syntax for inserting data into a table named Members?

INSERT INTO MEMBERS 

           (MEMBER_ID, LASTNAME, FIRSTNAME) 

     VALUES (‘1432’, ‘Smith’, ‘Charles’) 

Question 2) When using the DELETE statement to remove data from a database, what does the WHERE clause do?

It indicates the condition under which the data should be deleted; for example, which rows should have their contents deleted. 

Question 3) A single INSERT statement can be used to insert multiple rows in a table. True or False?

True

Question 4) Which SELECT statement eliminates duplicates in the result set?

 SELECT DISTINCT(country) FROM author

Question 5) The SELECT statement is called a query, and the output we get from executing the query is called a result set. True or False?

True

Graded Quiz: ORM - Bridging the Gap Between the Real World and Relational Model

Question 1) Which of the following is a benefit of using ORM?

Speeds up application development 

Question 2) When you create an object (an instance of a class) in Django, what does it represent?

Table row

Question 3) What does Django create when you create a forward relationship?

Backward access

Question 4) To delete() records in a database, you call the Delete method on which objects?

Model object or QuerySet

Question 5) What is the main reason ORM was invented?

Bridge the gap between OOP and SQL

Question 6) Multi-table inheritance is like which relationship?

One-to-one

Question 7) What method would you use to create a subset of database records?

Filter

Question 8) How do you specify what happens to related objects when an object is deleted?

on_delete 

Question 9) Django only requires that model relationships be defined on one side. What is this called?

Forward access

Graded Quiz: Full-stack Django Development

Question 1) What else does the Django template contain besides Python code?

Static HTML elements

Question 2) Three files are created by Django after you've created a project. Which of these files is a command-line interface used to interact with the Django project?

manage.py

Question 3) For the onlinecourse example, when registering the course and instructor models in the Django admin site, you would write and run "admin.site.register(Course)" and what other code statements?

admin.site.register(Instructor)

Question 4) When you map a URL to the course view, what file do you add path objects to?

urls.py

Question 5) Django template files display content, such as course names and descriptions. How is the content displayed?

HTML

Question 6) Which is one of the differences between the Django MVT and the MVC design pattern?

 

The Django framework or Django server itself acts as controller

Question 7) What two development tasks need to be performed to manage and determine which data will be presented to the UI?

Model data and create views

Question 8) Which command is used in the Django Admin video to start the server?

python manage.py runserver

Question 9) Django functions, like View, accept arguments as input and return something. Typically, View needs an HTTP request object as the first argument. What does this request object contain?

Read-only HTTP metadata

Question 10) Django template file structure sometimes has two files created with the same name. How do you ensure Django points to the correct file?

Name spacing

Graded Quiz: Consolidate and Deploy Your Django App

Question 1) Django class-based view needs to be mapped with a URL pattern, almost like configuring the URL for the function-based view. The only difference is you need to specify:

The as_view function

Question 2) Username and password can be received from a user via a login HTML template. Which HTTP method is used to sent username/password to the onlinecourse login view, in order to authenticate the user?

POST request 

Question 3) In the Django Bootstrap video, a course index page is designed that contains courses represented as cards. The multiple course cards are then added to a container. How are the multiple course cards managed?

Wrapped in a card deck

Question 4) Django provides a default staticfiles app that collects all static files in a single directory. You can move all static files to this directory when you deploy your app to a production web server. There are several steps to do this. What call do you make in the last step?

Run ‘collectstatic’ command line

Question 5) ASGI is another web server interface that Django apps support. What is the main difference between WSGI and ASGI?

ASGI supports asynchronous code

Question 6) Which type of view was created to address view extensibility and reusability?

Class-based view

Question 7) Does authorization occur before, after, or during the authentication process?

After authentication

Question 8) How can you use Bootstrap CSS style classes without manually downloading and importing it?

Add a link to the latest Bootstrap version into the head element of your HTML template 

Question 9) Django apps can have app-specific static files but can also have external static files. Where do you define the directories for external static files, so you can find them?

In the STATICFILES_DIRS list in settings.py file

Question 10) WSGI is the main Python standard for communicating between web servers and applications. To make Django apps work with WSGI the startproject command line creates a file that declares an application callable by default. What is this file named?

wsgi.py

Also Check: Cybersecurity Roles, Processes & Operating System Security All Quiz Answers - Coursera!