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 of the following is NOT a type of SQL statement?

2 / 20

Which of the following is a valid SQL command to create a new database?

3 / 20

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

4 / 20

In SQL, what does DML stand for?

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

5 / 20

Which SQL function is used to return the smallest value in a set of records?

6 / 20

Which symbol is used to terminate an SQL statement?

7 / 20

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

8 / 20

What does SQL stand for?

9 / 20

What kind of database does SQL typically work with?

10 / 20

Which of the following is a valid SQL keyword?

11 / 20

Which of the following is used to add a new record into a table?

12 / 20

Which of the following can be used to limit the number of rows returned in a SQL query?

13 / 20

In SQL, which of the following is used to filter the results returned by a query?

14 / 20

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

15 / 20

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

16 / 20

What does the WHERE clause do in SQL?

17 / 20

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

18 / 20

Which SQL keyword is used to create a new table?

19 / 20

What is a primary key in a SQL table?

20 / 20

What is SQL primarily used for?

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.