Web Application Technologies and Django | Week 5

Course Name: Django for Everybody

Sub-course: Web Application Technologies and Django

Course Link: Django for Everybody

Sub-course Link: Web Application Technologies and Django

These are answers of Web Application Technologies and Django Week 5 Answers Coursera Quiz


Basic SQL

Q1. Structured Query Language (SQL) is used to (check all that apply)

  • Delete data
  • Create a table
  • Insert data
  • Run python

Answer: Delete data, Create a table, Insert data


Q2. Which of these is the correct syntax to make a new database using command line?

  • CREATE people;
  • CREATE DATABASE people;
  • MAKE people;
  • MAKE DATASET people;

Answer: CREATE DATABASE people;


These are answers of Web Application Technologies and Django Week 5 Answers Coursera Quiz


Q3. “INSERT INTO” is the keyword used to insert data into tables.

  • True
  • False

Answer: True


Q4. Which keyword is used to add conditions to your query?

  • WHERE
  • IF
  • ONLYIF
  • SELECT

Answer: WHERE


These are answers of Web Application Technologies and Django Week 5 Answers Coursera Quiz


Q5. Which command is used to retrieve all records from the table Users?

  • RETRIEVE all FROM Users
  • SELECT all FROM Users
  • RETRIEVE * FROM Users
  • SELECT * FROM Users

Answer: SELECT * FROM Users


Q6. Which keyword will cause the results of the query to be displayed in sorted order?

  • GROUP BY
  • WHERE
  • ORDER BY
  • None of these

Answer: ORDER BY


These are answers of Web Application Technologies and Django Week 5 Answers Coursera Quiz


Q7. The LIMIT clause helps to narrow down the number of rows returned by the query.

  • True
  • False

Answer: True


Q8. Images, PDFs, and movies cannot be stored in a database.

  • True
  • False
See also  Django Features and Libraries | Week 5

Answer: False


Q9. A primary key can be set to null.

  • True
  • False

Answer: False


These are answers of Web Application Technologies and Django Week 5 Answers Coursera Quiz


More Weeks of this course: Click Here

More Coursera Courses: http://progiez.com/coursera


These are answers of Web Application Technologies and Django Week 5 Answers Coursera Quiz