SQL Basics Quiz Questions

Last Updated :
Discuss
Comments

Question 1

What does SQL stand for?

  • A

    Structure Query Language


  • B

    Sequential Query Language

  • C

    Systematic Query Language


  • D

    Structured Question Language

Question 2

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

  • A

    FETCH

  • B

    EXTRACT

  • C

    SELECT

  • D

    RECOVER

Question 3

What is the purpose of the WHERE clause in SQL?

  • A

    To specify which columns to select

  • B

    To specify which table to select from

  • C

    To filter rows based on a specified condition

  • D

    To order the results

Question 4

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

  • A

    MODIFY

  • B

    UPDATE

  • C

    ALTER

  • D

    CHANGE

Question 5

What does the SQL keyword "GROUP BY" do?

  • A

    Orders the result set in ascending order

  • B

    Group rows that have the same values into summary rows

  • C

    Filters rows based on a specified condition

  • D

    Joins two or more tables

Question 6

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

  • A

    AND

  • B

    OR

  • C

    NOT

  • D

    LIKE

Question 7

What does the SQL keyword "ORDER BY" do?

  • A

    Filters rows based on a specified condition

  • B

    Group rows that have the same values into summary rows

  • C

    Orders the result set based on specified columns

  • D

    Joins two or more tables

Question 8

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

  • A

    TRUNCATE

  • B

    DELETE

  • C

    DROP

  • D

    REMOVE

Question 9

What does the SQL keyword "DISTINCT" do?

  • A

    Filters duplicate rows from the result set

  • B

    Orders the result set in ascending order

  • C

    Group rows that have the same values into summary rows

  • D

    Joins two or more tables

Question 10

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

  • A

    MODIFY

  • B

    INSERT

  • C

    ALTER

  • D

    ADD

There are 10 questions to complete.

Take a part in the ongoing discussion