Home > Databases > Quizzes > SQL Fundamentals Test
SQL Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 16% • Most missed: “What function counts the number of rows in a column?”
SQL Fundamentals Test
Time left 00:00
25 Questions

1. Which of the following is NOT a valid aggregate function?
2. What is the correct procedure to create and use a cursor?
3. If you INNER JOIN tableA (which has 10 rows) with tableB (which has 5 rows) - what is the smallest possible amount of rows that can be returned?
4. Suppose table A has 5 rows and table B has 6 rows. You perform a cross join on these two tables. How many rows will it have?
5. What is the name of a mechanism used to associate tables within a SELECT statement?
6. If a foreign key constraint is violated - the default action taken by the DBMS is what?
7. Which symbol can be used to indicate a 'wild card' to substitute for one or more characters when searching for string in a database?
8. What does SQL stand for?
9. Which of the following statements can be used to undo a transaction?
10. In SQL what is the meaning of NULL?
11. What keyword is used with aggregate functions to include only unique values in the calculation?
12. Which of the following names is NOT a SQL based RDBMS?
13. What function is used to remove padded spaces?
14. Which of the following is NOT true about a primary key constraints?
15. What is the typical filename extension of a SQL file?
16. What clause is used to sort data and group it?
17. Which statement removes all rows from the 'orders' table without removing the table structure?
18. What is the correct syntax for using a CASE statement?
19. What is an alternate way of writing the following statement: WHERE 'column_name' IN ('value1')
20. Choose correct clause: SELECT CountryCode - COUNT(*) FROM City GROUP BY CountryCode _____ COUNT(*) > 20;
21. Which SQL function or feature returns a single value - calculated from values in a column?
22. How many primary keys can a table have?
23. Which of these is not a language element of SQL?
24. What is the first query to run in a statement that contains subqueries?
25. Which is the correct order for a proper SQL query?

⚡ 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 MCQs MariaDB Practice Test
 
❤ 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.