SQL Basics Quiz Questions

Structured Query Language, is the standard language used to interact with relational databases. Whether you're a newcomer looking to grasp the fundamentals or a seasoned professional refreshing your knowledge, this quiz will test your understanding of SQL essentials.

Question 1

What does SQL stand for?

• Structure Query Language

• Sequential Query Language

• Systematic Query Language

• Structured Question Language

Question 2

Which SQL keyword is used to retrieve data from a database?

• FETCH

• EXTRACT

• SELECT

• RECOVER

Question 3

What is the purpose of the WHERE clause in SQL?

• To specify which columns to select

• To specify which table to select from

• To filter rows based on a specified condition

• To order the results

Question 4

Which SQL statement is used to update data in a database?

• MODIFY

• UPDATE

• ALTER

• CHANGE

Question 5

What does the SQL keyword "GROUP BY" do?

• Orders the result set in ascending order

• Group rows that have the same values into summary rows

• Filters rows based on a specified condition

• Joins two or more tables

Question 6

Which SQL operator is used to combine two or more conditions in a WHERE clause?

• AND

• OR

• NOT

• LIKE

Question 7

What does the SQL keyword "ORDER BY" do?

• Filters rows based on a specified condition

• Group rows that have the same values into summary rows

• Orders the result set based on specified columns

• Joins two or more tables

Question 8

Which SQL statement is used to delete data from a database?

• TRUNCATE

• DELETE

• DROP

• REMOVE

Question 9

What does the SQL keyword "DISTINCT" do?

• Filters duplicate rows from the result set

• Orders the result set in ascending order

• Group rows that have the same values into summary rows

• Joins two or more tables

Question 10

Which SQL statement is used to add a new column to an existing table?

• MODIFY

• INSERT

• ALTER

• ADD