Coursera Answers

Introduction to Structured Query Language (SQL) Week 2 Practice Quiz Answer

Introduction to Structured Query Language (SQL) Week 2 Practice Quiz Answer

SQL Queries

Question 1)
DBA stands for

  • database administrator

 

Question 2)
Structured Query Language (SQL) is used to (check all that apply)

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

 

Question 3)
Which statement is the right syntax to make a new database using command line?

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

 

Question 4)
“INSERT INTO” is the keyword used to insert data into tables.

  • True
  • False

 

Question 5)
Which keyword is used to add conditions to your query?

  • IF
  • WHERE
  • ONLYIF
  • SELECT

 

Question 6)
Which command is used to retrieve all records from the table?

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

 

Question 7)
Which keyword will cause the results of the query to be displayed in sorted order?

  • GROUP BY
  • ORDER BY</span >
  • WHERE
  • None of these

 

Question 8)
The LIMIT clause helps to narrow down the scope of the query.

  • True
  • False

 

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

  • VARCHAR

 

Question 10)
A column of type CHAR cannot be indexed.

  • True
  • False

 

Question 11)
Images, PDF, movies cannot be stored in a database.

  • True
  • False

 

Question 12)
Column of type TIMESTAMP stores the number of seconds from January 1, [_____] in the column.
  • 1970

 

Question 13)
A primary key can be set to null.

  • True
  • False

 

Question 14)
An UNSIGNED int can be a negative number.

  • True
  • False

 

Question 15)
Primary keys are used to distinguish rows within in a table. [_____] keys are used to reference the primary key from a different table.
  • foreign