All Coursera Quiz Answers

Test your knowledge: SQL queries Quiz Answers

In this article i am gone to share Coursera Course: Tools of the Trade: Linux and SQL Week 4 Practice Quiz | Test your knowledge: SQL queries Quiz Answers with you..ย 

Enroll Link: Tools of the Trade: Linux and SQL


Also Visit:ย  Test your knowledge: SQL and databases Quiz Answers


 

Test your knowledge: SQL queries Quiz Answers

Question 1)
What is filtering in SQL?

  • Changing a table to match a condition
  • Selecting data that match a certain condition
  • Removing unnecessary data from the database
  • Removing invalid records

Question 2)
You are working with the Chinook database and want to return the firstname, lastname, and phone of all employees. Replace –??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)

–???FROM employees;
–???
FROM employees;

What is Andrew Adams’ phone number?

  • +1 (780) 836-9987
  • +1 (403) 467-3351
  • +1 (403) 262-3443
  • +1 (780) 428-9482

Question 3)
A security analyst wants to filter the log_in_attempts table for records where the value in the country column is ‘Canada’. What is a valid query for this?

  • SELECT * FROM log_in_attempts WHERE country = ‘Canada’; WHERE country = ‘Canada’
  • SELECT * FROM log_in_attempts;
  • SELECT WHERE country = ‘Canada’ FROM log_in_attempts;
  • SELECT * FROM log_in_attempts WHERE country = ‘Canada’;

Question 4)
Which pattern matches with any string that starts with the character ‘A’?

  • ‘%A’
  • ‘%A%’
  • ‘A%’
  • ‘A’