Introduction to SQL – Quiz

Introduction to SQL

This quiz will test your basic understanding of SQL (Structured Query Language). The questions cover fundamental concepts such as SQL syntax, the purpose of SQL, databases, and how SQL operates. The goal is to ensure a solid foundation before diving into more advanced topics.

1 / 20

Which SQL statement is used to change data in a table?

2 / 20

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

3 / 20

What does SQL stand for?

4 / 20

What is SQL primarily used for?

5 / 20

What is a table in a database?

6 / 20

What does the WHERE clause do in SQL?

7 / 20

Which SQL clause is used to sort the result set?

8 / 20

What does the SQL DISTINCT keyword do?

9 / 20

In SQL, what does DML stand for?

  • a) Data Markup Language
  • b) Data Modification Language
  • c) Data Manipulation Language
  • d) Data Management Language

10 / 20

Which SQL command is used to modify existing data in a table?

11 / 20

SQL is a standard language used to communicate with what type of system?

12 / 20

What kind of database does SQL typically work with?

13 / 20

Which symbol is used to terminate an SQL statement?

14 / 20

Which of the following is a valid SQL keyword?

15 / 20

Which of the following is NOT a part of SQL’s Data Manipulation Language (DML)?

16 / 20

What is a primary key in a SQL table?

17 / 20

Which SQL clause is used to specify conditions in a query?

18 / 20

Which SQL keyword is used to remove duplicate records in a result set?

19 / 20

Which SQL command is used to remove all rows from a table without deleting the table itself?

20 / 20

Which of the following is NOT a relational database?

Your score is

The average score is 90%

0%

This quiz will test your basic understanding of SQL (Structured Query Language). The questions cover fundamental concepts such as SQL syntax, the purpose of SQL, databases, and how SQL operates. The goal is to ensure a solid foundation before diving into more advanced topics.