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
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.
Question 5) Which keyword is used to add conditions to your query?
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 >
- None of these
Question 8) The LIMIT clause helps to narrow down the scope of the query.
A [_____] column allocates a string with a variable amount of space depending on the data length that is actually stored.
Question 10) A column of type CHAR cannot be indexed.
Question 11) Images, PDF, movies cannot be stored in a database.
Question 12) Column of type TIMESTAMP stores the number of seconds from January 1, [_____] in the column.
Question 13) A primary key can be set to null.
Question 14) An UNSIGNED int can be a negative number.
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.