SQL Quiz

The SQL quiz determines whether you understand the fundamentals of this database language. Once you pass the SQL quiz with a high enough score, you should move onto more tutorials to get a more well-rounded knowledge of web development. This test is MySQL syntax, which might change your answers on a few questions.

1. What type of query gets information from a database?

 
 
 
 

2. What type of query removes information from a database?

 
 
 
 

3. What type of query can change content in a database?

 
 
 
 

4. What type of query can add new information into the database?

 
 
 
 

5. In the query “SELECT address FROM users”, what is the column being selected?

 
 
 
 

6. What is the keyword you would use before adding conditions to your query?

 
 
 
 

7. What keyword wraps the data that you would like to insert in an INSERT query?

 
 
 
 

8. What is the keyword you would use in an UPDATE query to modify the existing value?

 
 
 
 

9. If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?

 
 
 
 

10. To sort your results by a column name, what keyword would you use before the column name?

 
 
 
 

11. What keyword would you use to group your results by a column’s values?

 
 
 
 

12. When sorting your results by a column’s values that are integers, what keyword would you use to sort from greatest to least?

 
 
 
 

13. If you are only retrieving one column’s values, what keyword can you add before the column name to only return unique values?

 
 
 
 

14. What keyword can you use to search for a string in a column?

 
 
 
 

15. What keyword can you use to merge two tables based on a matching column?

 
 
 
 

16. What function can you use to add all of a column’s values together?

 
 
 
 

17. What function would you use to return the highest value of a column?

 
 
 
 

18. What function can you use to compare dates?

 
 
 
 

19. What function would you use to round all values up?

 
 
 
 

20. What function would you use to round all numbers down?

 
 
 
 

Question 1 of 20