All Coursera Quiz Answers

Module quiz: SQL operators and sorting and filtering data Quiz Answers

In this article i am gone to share Coursera Course: Introduction to Databases for Back-End Development by Meta Week 3 | Module quiz: SQL operators and sorting and filtering data Quiz Answers with you..

Also visit:ย  Module quiz: Create, Read, Update and Delete (CRUD) Operations Quiz Answers

 

Module quiz: SQL operators and sorting and filtering data

Question 1)
Which of the following SQL statements adds a $2.00 service fee to the total price in a table called “Orders”, that lists the price of orders customers placed with a store?

  • SELECT total + 2 FROM Orders;
  • SELECT total + 2 FROM the Orders TABLE;
  • SELECT total + 2 FROM Orders TABLE;

Question 2)
What does the following SQL statement do?

SELECT total / 2 FROM Orders;
  • It returns the result of total price divided by 2 for each cell in the total price column
  • It returns the value of total price column in the second row.

Question 3)
The following SQL statement returns 2 percent of the total price:

SELECT total % 2 FROM Orders;
  • True
  • False

Question 4)
Which of the following SQL statements returns 50% of the total price? Choose all correct answers.

  • SELECT total * 50 FROM Orders;
  • SELECT total / 2 FROM Orders;
  • SELECT total * 0.5 FROM Orders;
  • SELECT total / 50% FROM Orders;

Question 5)
Select the right SQL statement to display the values of the total prices that are greater than $140.

  • SELECT total FROM Orders WHERE total < 140;
  • SELECT total FROM Orders WHERE total >= 140;
  • SELECT total FROM Orders WHERE total > 140;

Question 6)
Does the following SQL statements sort the result-set of the total prices in ascending or descending order?

SELECT * FROM Orders ORDER BY total;
  • Descending
  • Ascending

Question 7)
The following SQL statement filters data based on ____

SELECT * FROM customers WHERE Country = "Germany";
  • ‘Germany’ column with ‘country’ value
  • ‘Country’ column with ‘Germany’ value

Question 8)
In SQL you can sort records in descending order using the DESCENDING keyword.

  • False
  • True

Question 9)
The output of the following SQL query within the Orders table is: UK, UK, UK, France, France, Finland

SELECT DISTINCT Country FROM Orders;
  • True
  • False

Question 10)
What does the following SQL statement do?

SELECT * FROM Orders ORDER BY country, total;
  • Orders the result by country first then total price.
  • Orders the result by country and ignores the total price.