Nexus Learn

Databases and SQL MCQs with answers

Almost every application stores data in a database. These questions cover relational database ideas and the SQL commands you will use most often.

Answered 0 / 10 Correct 0
1 Which SQL clause filters rows before they are grouped?
2 Which clause filters the groups produced by GROUP BY?
3 A primary key must be...
4 Which command removes a table and its structure from the database?
5 Which join returns only the rows that match in both tables?
6 In ACID, what does the letter A stand for?
7 Third Normal Form (3NF) removes which kind of dependency?
8 What does a foreign key do?
9 Which expression counts all rows in a table?
10 What does SELECT DISTINCT do?

More practice

Keep learning with the free course notes and slides or try the GPA calculator.