SQL Basics Assessment

Instruction

1. Read each question carefully and select the best possible answer.
2. Choose only one answer for each question.
3. You can click on show all questions to see all questions in one page.
4. After submitting all answers, Final result will be displayed on your screen

Basic SQL Exercise

Quiz

 

1. Which of the following is not a basic SQL data type?
   1.   Integer
   2.   Text
   3.   Boolean
   4.   Array
2. Which SQL statement is used to retrieve data from a database?
   1.   SELECT
   2.   INSERT
   3.   UPDATE
   4.   DELETE
3. Which SQL keyword is used to filter data in a SELECT statement?
   1.   FILTER
   2.   WHERE
   3.   HAVING
   4.   GROUP BY
4. Which SQL clause is used to sort data in ascending or descending order?
   1.   GROUP BY
   2.   ORDER BY
   3.   HAVING
   4.   SORT BY
5. Which SQL function is used to count the number of rows in a table?
   1.   SUM
   2.   COUNT
   3.   AVG
   4.   MAX
6. Which SQL operator is used to combine two or more conditions in a WHERE clause?
   1.   AND
   2.   OR
   3.   NOT
   4.   XOR
7. Which SQL statement is used to add new rows to a table?
   1.   UPDATE
   2.   DELETE
   3.   INSERT
   4.   ALTER
8. Which SQL statement is used to modify existing data in a table?
   1.   INSERT
   2.   UPDATE
   3.   DELETE
   4.   ALTER
9. Which SQL statement is used to remove rows from a table?
   1.   INSERT
   2.   UPDATE
   3.   DELETE
   4.   ALTER
10. Which SQL statement is used to modify the structure of a table?
    1.   INSERT
    2.   UPDATE
    3.   DELETE
    4.   ALTER