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.

Last Updated :
Discuss
Comments

Question 1

What does SQL stand for?

  • Structure Query Language


  • Sequential Query Language

  • Systematic Query Language


  • Structured Question Language

Discuss it

Question 2

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

  • FETCH

  • EXTRACT

  • SELECT

  • RECOVER

Discuss it

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

Discuss it

Question 4

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

  • MODIFY

  • UPDATE

  • ALTER

  • CHANGE

Discuss it

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

Discuss it

Question 6

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

  • AND

  • OR

  • NOT

  • LIKE

Discuss it

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

Discuss it

Question 8

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

  • TRUNCATE

  • DELETE

  • DROP

  • REMOVE

Discuss it

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

Discuss it

Question 10

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

  • MODIFY

  • INSERT

  • ALTER

  • ADD

Discuss it

There are 10 questions to complete.

Take a part in the ongoing discussion
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy