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
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