All Coursera Quiz Answers

Introduction to SQL Week 2 Practice Quiz Answers

Hello Friends in this article i am gone to share Introduction to Introduction to SQL Week 2 Practice Quiz Answers with you.

Introduction to Structured Query Language Week 2 Practice Quiz Answer


Also visit this link:  Introduction to Structured Query Language Week 3 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