SQL Basics QuizOnline version Test your knowledge of SQL with this fun quiz game! by Tony Dominguez Cruz 1 What does SQL stand for? a Standard Query Language b Sequential Query Language c Structured Query Language d Simple Query Language 2 Which command is used to retrieve data from a database? a GET b FETCH c PULL d SELECT 3 What keyword is used to filter records in SQL? a WHERE b HAVING c FILTER d SELECT 4 Which SQL statement is used to update existing records? a CHANGE b MODIFY c UPDATE d ALTER 5 What is the purpose of the GROUP BY clause? a To join tables b To group rows that have the same values c To filter rows d To sort rows 6 Which SQL function is used to count the number of rows? a TOTAL() b NUMBER() c COUNT() d SUM() 7 What does the JOIN clause do? a Combines rows from two or more tables b Filters rows c Sorts rows d Deletes rows 8 Which SQL statement is used to create a new table? a NEW TABLE b ADD TABLE c CREATE TABLE d MAKE TABLE 9 What is the default sorting order in SQL? a Descending b Random c Unsorted d Ascending 10 Which SQL command is used to delete records? a DROP b ERASE c REMOVE d DELETE 11 What does SQL stand for? a Standard Query Language b Simple Query Language c Structured Query Language d Sequential Query Language 12 Which SQL statement is used to update data in a database? a EDIT b MODIFY c CHANGE d UPDATE 13 What is the purpose of the JOIN clause in SQL? a To create tables b To combine rows from two or more tables c To filter rows d To delete rows 14 Which SQL function is used to count the number of rows? a COUNT() b TOTAL() c ADD() d SUM() 15 What keyword is used to sort the result set in SQL? a ARRANGE BY b SORT BY c ORDER BY d GROUP BY 16 What does the GROUP BY clause do? a Groups rows sharing a property b Filters rows c Sorts rows d Joins tables 17 Which SQL command is used to remove a table? a CLEAR TABLE b REMOVE TABLE c DELETE TABLE d DROP TABLE 18 What is a primary key in SQL? a A duplicate identifier b A unique identifier for a record c A foreign key d An index 19 Which SQL clause is used to filter records? a SELECT b HAVING c WHERE d FILTER 20 What does the DISTINCT keyword do? a Removes duplicate records b Sorts records c Groups records d Counts records
New game