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