• Tutorials
  • DSA
  • Data Science
  • Web Tech
  • Courses

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

There are 10 questions to complete.

Last Updated :
Take a part in the ongoing discussion