Introduction to Structured Query Language (SQL) Week 1 Quiz Answers - Coursera!

Introduction to Structured Query Language (SQL) complete course is currently being offered by University of Michigan through Coursera platform.

This course is part of the Web Applications for Everybody Specialization.

About this Course: 

In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

SKILLS YOU WILL GAIN

- Phpmyadmin

- MySQL

- Relational Database

- SQL

Also Check: How to Apply for Coursera Financial Aid

Course Link: https://www.coursera.org/learn/intro-sql

Introduction to Structured Query Language (SQL) Week 1 Quiz Answers

SQL Queries

Q1. Which statement is the right syntax to make a new database using command line?

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

Q2. DBA stands for

• Database administrator

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

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

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

• True
• False

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

• IF
• WHERE
• ONLYIF
• SELECT

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

• SELECT all FROM Users
• RETRIVE * FROM Users
• RETRIVE all FROM Users
• SELECT * FROM Users

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

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

Q8he LIMIT clause helps to narrow down the scope of the query.

• True
• False

Q9.A [_____] column allocates a string with a variable amount of space depending on the data length that is actually stored.

• varchar

Q10. A column of type CHAR cannot be indexed.

• True
• False

Q11. Images, PDF, movies cannot be stored in a database.

• True
• False

Q12. Column of type TIMESTAMP stores the number of seconds from January 1, [_____] in the column.

• 1970

Q13. A primary key can be set to null.

• True
• False

Q14. An UNSIGNED int can be a negative number.

• True
• False

Q15. Primary keys are used to distinguish rows within in a table. [_____] keys are used to reference the primary key from a different table.

• Foreign