SQL Basics

Quiz Questions

1. Which SQL keyword is used to retrieve data from a database?
   • GET
   • FETCH
   • SELECT
   • RETRIEVE
2. What does the WHERE clause do?
   • Sorts records
   • Filters records
   • Groups records
   • Joins tables
3. Which SQL statement is used to insert new data?
   • ADD
   • INSERT INTO
   • CREATE
   • UPDATE
4. What does SQL stand for?
   • Structured Query Language
   • Simple Query Language
   • Standard Query Language
   • Sequential Query Language
5. Which clause is used to sort the result set?
   • SORT BY
   • ORDER BY
   • GROUP BY
   • ARRANGE BY
6. What is the purpose of the GROUP BY clause?
   • To filter groups
   • To sort data
   • To group rows with same values
   • To join tables
7. Which function returns the number of rows?
   • SUM()
   • COUNT()
   • TOTAL()
   • NUM()
8. What does DISTINCT keyword do?
   • Removes duplicates
   • Counts unique values
   • Sorts uniquely
   • Filters distinct
9. Which JOIN returns all rows when there is a match in either table?
   • INNER JOIN
   • LEFT JOIN
   • RIGHT JOIN
   • FULL OUTER JOIN
10. How do you select all columns from a table named 'users'?
    • SELECT users
    • SELECT ALL FROM users
    • SELECT * FROM users
    • SELECT [all] FROM users