Home > Databases > Quizzes > Introduction to SQL Questions
Introduction to SQL Questions
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 66% Most missed: “What is the foreign key?”

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria. The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2='value';

Introduction to SQL Questions
Time left 00:00
25 Questions

1. How do you query for a single quote inside a string?

2. What is the opposite of LIKE?

3. How can you query multiple columns (see a subset of fields) in one command?

4. What is GO for?

5. Write a multiple filter BETWEEN statement

6. How do you add a row into a database table?

7. What is the difference between % and _ in a LIKE query?

8. What is the condition needed for an INNER JOIN?

9. What is an SQL clause?

10. Use COUNT and WHERE together

11. Name commands you can use to filter the results set in your query.

12. How do you add a column to a database table? The table is celebs and the column will be twitter_handle.

13. What are the four data types in SQL?

14. How would you sort by a particular column?

15. What is CRUD

16. What is the predicate?

17. What is an aggregate function?

18. How do you write comments in SQL?

19. Add up the number of downloads per category.

20. What do you call that which is returned from a SELECT statement?

21. How do you go vertical on your postgres CLI?

22. How do you connect to a database in postgres?

23. How best to provide database context for your query?

24. How do you query for special characters like % and _ (not use them as wildcards)?

25. Return the three lowest rated movies.