Home > Databases > Quizzes > SQL: Structured Query Language
SQL: Structured Query Language
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 4% • Most missed: “_______ column name FROM table name”
SQL: Structured Query Language
Time left 00:00
25 Questions

1. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.

2. A language designed specifically for communicating with databases.

3. A popular open source database

4. The container - usually a file or set of files - to store organized data

5. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.

6. COUNT() - MAX() - MIN() - SUM() and AVG()

7. Used to nest subqueries within another subquery.

8. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.

9. A reserved word that is part of the SQL language. Never name a table or column using a keyword.

10. Provides a numerical tally of how many rows meet a specific set of criteria.

11. A structured list of data of a specific type

12. Denotes that the search condition is TRUE for at least one element that the subquery returns.

13. A type of allowed data. Every table column has a datatype that restricts specific data in that column.

14. Allows a comparison with multiple values from a list.

15. _______ column name FROM table name

16. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.

17. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.

18. NOT - AND - OR

19. SQL is a language NOT an _______

20. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.

21. Lets you change the values in one or more selected rows of a table.

22. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.

23. Used to select all the information in a specified column.

24. Allows you to delete selected rows.

25. SQL statements are case- insensitive

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.